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 have many projects. I have that part built however when it comes to the form I seem to be going in circles. Any suggestion would be super. 

Thank you in advance for your help. 
Joe

------------------------------
D'Argent Companies
------------------------------
  • 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
        ------------------------------