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 c...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendThis 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
------------------------------
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
------------------------------
- Thanks Mark! I ended up doing this and it has been working great!
------------------------------
Yasmin Boyrati
------------------------------
