one to many relationship?

[cowboy]

I have a list of people in a list box and when I select someone in the list box I want however many addresses that person has in another list box or sub form. What is the best way to set this up?



I was trying to do this by having a query that got the unique identifier that matches the tables but when I tried to pass the parameter it didnt do anything, just displayed a blank query .... the code is:

PARAMETERS [Forms]![MainForm]![lstPeople]![Column(0)] IEEEDouble;
SELECT Addresses.AdrID, Addresses.PID, Addresses.Address, Addresses.City, Addresses.State, Addresses.ZipCode
FROM Addresses
WHERE (([PID] = [Forms]![MainForm]![lstPeople]![Column(0)]));

Then I was going to try to set another list box to get its row source from the query. This didnt work the way I wanted, am I on the right track or way off?

[Rawb]

Looks like all you need to do is change [Column(0)] to .Column(0) to fix the problem.

SELECT Addresses.AdrID, Addresses.PID, Addresses.Address, Addresses.City, Addresses.State, Addresses.ZipCode
FROM Addresses
WHERE ([PID] = [Forms]![MainForm]![lstPeople].Column(0));

[cowboy]

PARAMETERS [Forms]![MainForm]![lstPeople]![Column(0)] IEEEDouble;
SELECT Addresses.AdrID, Addresses.PID, Addresses.Address, Addresses.City, Addresses.State, Addresses.ZipCode
FROM Addresses
WHERE (([PID]=Forms!MainForm!lstPeople.Column(0)));

Gives me an error: "Undefined function 'Forms!MainForm!lstPeople.Column' in expression."

PARAMETERS [Forms]![MainForm]![lstPeople].Column(0) IEEEDouble;
SELECT Addresses.AdrID, Addresses.PID, Addresses.Address, Addresses.City, Addresses.State, Addresses.ZipCode
FROM Addresses
WHERE (([PID]=Forms!MainForm!lstPeople.Column(0)));


Gives me an error: "Syntax error in PARAMETER clause."

[Rawb]

Well, I know virtually nothing about the PAREMETERS statement but here goes. . .

PARAMETERS [Forms]![MainForm]!lstPeople Integer;
SELECT Addresses.AdrID, Addresses.PID, Addresses.Address, Addresses.City, Addresses.State, Addresses.ZipCode
FROM Addresses
WHERE (([PID]=[Forms]![MainForm]!lstPeople));