Forum Discussion

ZintJoseph's avatar
ZintJoseph
Qrew Captain
8 years ago

I am trying to build a project relationship which involves subcontractors, assigned subcontractors and subcontractor contacts

I am struggling to created the following relationship with the tables above Each project will have many assigned subcontractors Each subcontractor may have many contacts So when I assign a subc...
MCFNeil's avatar
MCFNeil
Qrew Captain
8 years ago
--> (Has many)

SubContractors --> Projects
SubContractors --> Contacts

Projects --> Sub Contacts
Contacts --> Sub Contacts

"Sub Contacts" is the joined table that allows you to add many contacts to one project.
You can make the selections conditional based on the Sub, so you have a narrow list to choose from.