I need to create a field(s) that allows me to select multiple records. Here's my tables and relationships: Activities & Contracts - I've got two relationships between them: Activities->Contracts and Contracts->Activities
Right now I want to be able to select which Contracts are associated with a certain Activity via the Activities table. I'd also like to eventually be able to select which Activities relate to a certain Contract via the Contracts table.
------------------------------
Bethany Dickey
------------------------------
Question
Many to Many
This topic has been closed for replies.
+24Right, so you need a vanilla many to many relationship setup, but your set up is incorrect. If you have no real data in those existing two relationships, then delete the relationships and start over as I will describe.
But if you do have a lot of data loaded, then we can late migrate the data as to which goes with which.
Make a new "middle" or "join" table called Contract Activities with no fields.
Make the Relationship were One Contract has Many Contract Activities. Be sure to set up a proper Proxy field such as Contract name for the field [Related contract].
Make the Relationship were One Activity has Many Contract Activities. Be sure to set up a proper Proxy field such as Activity name for the field [Related contract].
On the Contracts record form, put the field for Add Contract Activity and also the embedded table for Contract Activities and set the report to show on the form.
On the Activities record form, put the field for Add Contract Activity and also the embedded table for Contract Activities and set the report to show on the form.
Congrats, you are now a Many to many expert,. Thats's all there is to it.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
But if you do have a lot of data loaded, then we can late migrate the data as to which goes with which.
Make a new "middle" or "join" table called Contract Activities with no fields.
Make the Relationship were One Contract has Many Contract Activities. Be sure to set up a proper Proxy field such as Contract name for the field [Related contract].
Make the Relationship were One Activity has Many Contract Activities. Be sure to set up a proper Proxy field such as Activity name for the field [Related contract].
On the Contracts record form, put the field for Add Contract Activity and also the embedded table for Contract Activities and set the report to show on the form.
On the Activities record form, put the field for Add Contract Activity and also the embedded table for Contract Activities and set the report to show on the form.
Congrats, you are now a Many to many expert,. Thats's all there is to it.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.