Forum Discussion

YasminBoyrati's avatar
YasminBoyrati
Qrew Member
2 years ago

App-to-App Connections

I basically have 2 apps that are libraries for standard operating procedures (SOP) and control documents (CD). Each SOP can have multiple related CDs; each CD can be related to many SOPs. 

I have created an app-to-app relationship where SOPs can have many CDs and you select the related SOP via lookup in each CD form. On the SOP table I have a summary number of related CDs.

Now, I'm having trouble getting the second part of this- each CD can be related to many SOPs.
the lookup only allows to pick 1 value. Is there a way to multi-select text lookup? ​

------------------------------
Yasmin Boyrati
------------------------------

2 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    2 years ago
    This is a classic many to many situation.
    One SOP has Many CDs.
    One CD has many SOPs.

    So you need a middle join table.  Then the middle table will have lookups from parent tables (and may in fact have no manual fields at all) other than from the relationships and each parent record form will have an embedded report of the middle join table records.

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • YasminBoyrati's avatar
      YasminBoyrati
      Qrew Member
      2 years ago
      Thanks Mark! I ended up doing this and it has been working great!

      ------------------------------
      Yasmin Boyrati
      ------------------------------