A little database theory never hurts...

Let's take another look at our data model to better understand what we've done.

Here's how it works

1. Go to the database Event Management.
2. Activate editing mode .
3. Select the Database Settings and choose the option Data Model.

                The data model with the inserted links and sub-table

M:N Relationship

This now looks quite different compared to the last time when we looked at the 1:N relationship. We have now added another type of relationship, an M:N relationship, to our data model.

1. A consumption option (e.g., cake ) from the Food & Drinks table can be consumed at multiple events, meaning it can be linked to them.
2. And we can assume that at each event, different consumption options (e.g., cake , coffee , etc.) from the Food & Drinks table are offered.

As in most relational database systems, this connection type is also represented indirectly in Ninox, through a third table, the junction table.

 Through our table structure of Invoices and Invoice Items, the Events and Food & Drinks tables are connected.