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
1. Its best to create a table for each category (Contractors, Sub-Contractors, Contacts).
2. Make sure each table has a key field that is unique.
3. Decide which table will be your main table. This table will be on the many side of you "one-many" relationships. 
For example: if projects is your main table, your first relationship would be a "1-project to many-contractor", "1-project to many-Sub contractor", and a "1-contractor to many-contacts" relationship.

The parent would be able to write to the child and allow you to add more than one contact.