Joining Parent's In a Form

[ramasule]

So I have made my Link table to link properties to people.

PropertyTbl
PropertyID
Name

PersonTbl
PersonID
Name

PropPersonTbl
PropPersonID
PropertyID
PersonID

The relationships are set and it works great.

Now how would I go about making a form (and query) where I can
Load in the PropertyID/Name
and add in PeopleID/Name

So far all I have come up with is adding these in one at a time and I would like to attempt something like the following

CB = ComboBox
CBropertyID
CBerson1
CBerson2


Thanks,

Derek L

 

[llkhoutx]

Use the joined query as the recordsource for you form.

 

[ramasule]

ok so what do I put in the query?

 

[llkhoutx]

View the form's properties. Put the query name in the form's "Record Source" property.

 

[ramasule]

Hehe, I get that part

I was wondering what I should put In the Query.

What fields should I dump into it (the Query).

Thanks,
Derek L

 

[llkhoutx]

Whichever fields you want to display/add/update in the form; joined tables. Be certain to include all primary keys in the tables, otherwise you form recorset will be nonupdateable.