This type of relationship, where 1 record from one table can be assigned to many (N) records from another table, is called a 1:N relationship (i.e., 1 to N relationship).

Displaying Data Model in Ninox

Let’s take a look at this in Ninox using our example.

Here’s how:

1. Open the database (here: Event Management).

2. Enable Edit Mode .

3. In the Database Settings, select the Data Model option.

Data Model

In the data model, you can always see how your database is structured.

In our example, the Events table is displayed as a child table of the Company table.

Many (N) Events can be assigned to one (1) Company.

 If you delete a record in one of the tables, it will not affect the data in the other table. The two tables simply make information available to each other.

Sometimes it can be very helpful to establish closer relationships between tables...

 Want to dive deeper into the topic? Check out our video tutorial.