S
Sue
I know this is likely an elementary and stupid question, but I don't know how
to do this.
I have designed a database & want to have a form for data entry. I want my
subforms to draw records from different tables. 2 of my tables are:
tblContacts
tblBusiness
tblContacts has home address info, tblBusiness has work info (since there's
a many-to-many relationship for some contacts/businesses).
The main form is based on tblContacts. I can't figure out how to make the
subform "business" draw info from tblBusiness.
Help?
Thanks!
to do this.
I have designed a database & want to have a form for data entry. I want my
subforms to draw records from different tables. 2 of my tables are:
tblContacts
tblBusiness
tblContacts has home address info, tblBusiness has work info (since there's
a many-to-many relationship for some contacts/businesses).
The main form is based on tblContacts. I can't figure out how to make the
subform "business" draw info from tblBusiness.
Help?
Thanks!