How to create Many to Many relationships?
What is the best way to create a many-to-many relationship in Ninox? Do I create the intermediate table to join the two tables, as with other relational DBs?
Here is my scenario. We send newsletters. I would like to track which customers have been sent which newsletters. We have two tables: Contacts and Newsletters. I would normally create a third table to resolve the many:many relationship. Is there a better way to do this in Ninox?
3 replies
-
That sounds like a good way to go. The new table could even be a child of Newsletters. Then you would create a link in the "sent" table to Contacts.
-
How do I get the Contacts to appear as a subtable in the Newsletters form?
-
I thought you were going to create a new table? Make a new table, then drag a table reference to Newsletters and Contacts then under Newsletters set composition to Yes. You will need to create a new field like date delivered or sent or whatever so you can have some other data that is unique to this table.
Content aside
- 3 yrs agoLast active
- 3Replies
- 440Views