Record source on subform

[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!

 

[Sue]

I'm trying to normalize as much as possible so I wanted to separate tables
containing business and personal information. On the business subform, I want
to enter contact info (address, phone, pager, etc.)

 

[scubadiver]

Sorry, what you are trying to achieve isn't very clear. What distinguishes
business and personal information?

 

[Sue]

Sorry to obfuscate.
Personal info is home address, etc.
Business info is work address, etc.
For some people, I have - and need - both.

 

[scubadiver]

So you have a personal info table and business contacts table. You can't
enter information into a subform until the info in the main form has already
been entered (as least that is how I see it but maybe I am wrong on that)

All I see is that you select the ID from the business table into the FK
field in the junction table.

What you need to in the form wizard

1) select all the fields for your form
2) select all the fields for the junction table
3) create the form and subform
4) The ID field for the business info should use the main table as its source.

I appreciate that probably isn't very clear.