App-to-App Connections

Question

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
------------------------------

markshnier__you · Answer

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 · Answer

Thanks Mark! I ended up doing this and it has been working great!------------------------------Yasmin Boyrati------------------------------

Forum Discussion

App-to-App Connections