Hi Andrew,
Taking just the example of the Work Order: You mention there will be 3 contacts. Which seems like one work order has many contacts. However, what I believe you have is one Site Supervisor contact. That contact can be the Site Supervisor on many Work Orders. So the relationship would be: Many Work Orders to One Contact.
I would suggest creating one relationship for each of the three contact types. This should result in three drop down fields one your form (one for each contact type) with a list of contacts for you to select.
I hope I've understood your question. Please let me know if you have any follow-up questions or need clarification. Thanks and good luck.
Jake Rattner | Solutions Architect
(847) 927-1427 |
jrattner@quandarycg.comQuandary Knowledge Base