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
    Also you will want a joined for assigned Subs.  Sorry I skipped that one.
  • 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.