all entries to show up in form

Kekss

New member
Local time
Today, 06:59
Joined
Feb 25, 2005
Messages
5
I have table with different companies and related info. Another table with contacts for each of the companies, each company might have different number of contacts. I want the form to show all the contacts for each of the company, if there are two contacts in the company then show two, if five then show five.
Just to make sure I am doing it the right way, what is the best way to build a form that is based on multiple tables.
Thanks in advance,
John
 
Kekss,

Your form should have a main form for Companys. Then add a subform for the Contacts.
On the property sheet for the subform, set the Master-Child links to ContactID. Access
will synchronize the two forms.

Wayne
 

Users who are viewing this thread

Back
Top Bottom