This chapter shows how linked data can be imported into related tables.
Ninox builds table links solely based on the Ninox-own keys. As a key Ninox uses the No. column. The values of this column are assigned automatically and can not be changed. It is therefore not possible to change this column during the import.
Suppose you link a table “Invoices” to another table “Customers”. Then Ninox creates in the background in the table “Invoices” a field for the No. of customer.
Note, if you have previous experience with other databases: SQL, this would be equal roughly to ALTER TABLE “Invoices” ADD COLUMN “Customers” FOREIGN KEY REFERENCES customer (No).
To fill properly Invoices.Customer when importing this field, you need to give to the Import Wizard information enabling Ninox to identify the right customer to build up the relation.
The procedure to import relational data is illustrated by the example Invoices => customers. “Customers” is the main table and “Invoices” the detail table. (A customer can have multiple invoices.)
Preparing the data to be imported
Creating the tables in Ninox
Import in the main table
Import into the detail table
1. Preparing the data to be imported
The data must be in two csv files with the following exemplary structure: