Import CSV and make relations
I have 2 CSV files to import into Ninox. One is the main table and the other is a detail sub-table. The both have a common field a primary key in main table and as foreign key in detail sub-table.
I import the first table, no problem. When I import the details table, I do not see the matching field from the list of available fields in Ninox.
What am I doing wrong?
Andreas
3 replies
-
Thanks for the links though they are relative it was not what I was looking for.
I figured it out.
When you import a CSV file into an existing table, the destination table should have the relative primary key equivalant to the one being imported (contact_id = contact_id). If not, the imported table will use the default key set by the Ninox system and will not relate in any way with the sub-table which will be imported next.
Content aside
- 4 yrs agoLast active
- 3Replies
- 980Views