Forum Discussion

D_ArgentCompani's avatar
D_ArgentCompani
Qrew Member
6 years ago

Adding contact

I have a question about many to many relationships. I need to set up to have projects and contacts to both have many entries.  I need each project to have many contacts and I need each contact to hav...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
Did you set it up with a middle join table for Project Contacts?   Can you describe your relationships?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
D_ArgentCompani's avatar
D_ArgentCompani
Qrew Member
6 years ago
I have a link table that both are contact and project are connected to.

------------------------------
D'Argent Companies
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years ago
    You would put the report link from that Join table onto the respective records as (respective) embedded tables to show the records on the form.  Then make a two reports to use show the correct columns.  You will pull down any lookup fields that you need for that report such as Project Name and Contact name, down to the join table so they are available for those embedded reports.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------