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
CB
ropertyID
CB
erson1
CB
erson2
Thanks,
Derek L
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
CB

CB

CB

Thanks,
Derek L