I have a customer database which consists of 2 tables.
1. Companies
2. Contacts
In the relationships there is a one to many between company and contacts (often more than one contact at each company).
I now want to create a meetings notes table to log notes on meetings held. this will consist of 4 fields.
1. Company
2. Contact
3. Date
4. Notes
What i am trying to do is select a company (Lookup) and then when selecting which contacts from the company selected was present at the meeting.
So if i select the company [ABC TOURS] i want to then select from a lookup list of only contacts that work for ABC Tours. This could be multiple contacts.
Appreciate any help with this.
1. Companies
2. Contacts
In the relationships there is a one to many between company and contacts (often more than one contact at each company).
I now want to create a meetings notes table to log notes on meetings held. this will consist of 4 fields.
1. Company
2. Contact
3. Date
4. Notes
What i am trying to do is select a company (Lookup) and then when selecting which contacts from the company selected was present at the meeting.
So if i select the company [ABC TOURS] i want to then select from a lookup list of only contacts that work for ABC Tours. This could be multiple contacts.
Appreciate any help with this.