Skip to main content
Question

App-to-App Connections

  • August 19, 2022
  • 0 replies
  • 38 views
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
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24
    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
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement