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...
ClaudeBowens2's avatar
ClaudeBowens2
Qrew Trainee
8 years ago
The best solutions would be to setup 2 relationships:

Relationship 1: (between Projects and Sub-Contractor's Tables)
1 Project - Many Sub-Contractor Assignments, 

Relationship 2: (between Sub-Contractor's and Contacts Tables)
1 Sub-Contractor - Many Contacts

This will allow you to select multiple Sub-Contractor(s) for 1 project and multiple Contacts for 1 Sub-Contractor.