Drop down choices from 2 tables

Question

Hello everyone!&nbsp; Is it possible to create a drop down list where the choices are pulled from 2 different tables?&nbsp;&nbsp;
My situation is this:&nbsp; We are a custom sign manufacturer, so our projects have Customers (ie: "Bill To"), and Locations (ie: where the sign is being installed).&nbsp; Customers can have many contacts, and Locations have their own many contacts.&nbsp; For a specific project, I have it set up where we can choose the customer and then the contact and location.&nbsp; However, for the Location Contact, I want to be able to choose from both the Customer Contacts &amp; the Location Contacts.
I hope that made sense - thanks in advance for the help!------------------------------Allison Watson------------------------------

donlarson · Answer

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.&nbsp; &nbsp;
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------------------------------

Forum Discussion

Drop down choices from 2 tables