0

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

null
    • Fred
    • 3 yrs ago
    • Reported - view

    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.

    • fuchsia_carriage
    • 3 yrs ago
    • Reported - view

    How do I get the Contacts to appear as a subtable in the Newsletters form?

    • Fred
    • 3 yrs ago
    • Reported - view

    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
  • 415Views