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...
ZintJoseph's avatar
ZintJoseph
Qrew Captain
8 years ago
So no need for the Assigned Contractors table
MCFNeil's avatar
MCFNeil
Qrew Captain
8 years ago
And you'd probably want the Assigned contacts table to be a child of the joined subs.  
But depends on how big your contacts list is, and what user experience you'd want more.