What kind of relationship do I need?
Need some pointers on how to correctly setup my table relationships to be able to do the below. So I have three tables: Clients, Contacts, Work Orders. I am having difficulty getting the result ...
Forum Discussion
Regarding the need to set up multiple tables in your P.S.: You don't need to setup multiple tables. Instead just create multiple table-to-table relationships. You can create more than one relationship between two tables.
Then, you will need to filter those connections to display only the Site Supervisors in the 'Site Supervisor' dropdown field and Job Contacts in the 'Job Contact' field.
In order to do filter each dropdown you will need to use a field in the contacts table to categorize whether a contact is a Supervisor, Job Contact or Home Owner. Once you have those contacts categorized you should be able to use that field to filter your three drop-downs.
Jake Rattner | Solutions Architect
(847) 927-1427 | jrattner@quandarycg.com
Quandary Knowledge Base
Then, you will need to filter those connections to display only the Site Supervisors in the 'Site Supervisor' dropdown field and Job Contacts in the 'Job Contact' field.
In order to do filter each dropdown you will need to use a field in the contacts table to categorize whether a contact is a Supervisor, Job Contact or Home Owner. Once you have those contacts categorized you should be able to use that field to filter your three drop-downs.
Jake Rattner | Solutions Architect
(847) 927-1427 | jrattner@quandarycg.com
Quandary Knowledge Base
