Forum Discussion
DonLarson
2 years agoQrew Elite
Allison,
Assuming that each Project needs two Contacts that might be the same person but serve different roles, I would solve this with two tables, Customer Contact and Location Contacts that are both related to the Contacts table.
In the Project you would pick both roles even if they are the same person.
Here is how the tables would look.
Using Conditional Drop downs you can set it so that in the Projects table, you will have the full list of Contacts for the Customer.
Once you pick a Location for the Project, you get the smaller list that are Location Contacts.
------------------------------
Don Larson
------------------------------