I have a database with a main form which contains two subforms. The
main form holds data about name and address of a company. The first
subform holds tha contact data - name, position and DDI. The second
subform holds data on what activity has happened for that company with
fields for date, time, contact, action etc.
The contact field in the second subform does a lookup on the contacts
table, which holds the contact info for all companies. I would like
this to only show the contacts for that company and not all companies,
but can not work out how to do this.
Any suggestions????