0

Table architecture with a 3 levels or deeper hierarchy

Hello friends,

By any chance is it possible to have a Table architecture with a 3 levels or deeper hierarchy in Ninox?

Below is the current structure of my database and desitred structure (if possible) based on the type of data I have..

Is it possible to normalise the data in such a way. Ninox uses an internal field as Primary Key field that is numeric. Can we create a Composite Primary Key in  a table in Ninox? If that can be done, then this structure  might be possible.

So I want to have "Steel Post" as the main category, then sub categories and then grand sub categories.

 

Secondly, how can we put a UNIQUE constraint on a field in Ninox, so that the data entry operator is not able to enter duplicate values in that field. 

2 replies

null
    • Fred
    • 3 mths ago
    • Reported - view

    It can be confusing in Ninox with grandchild tables, because it doesn't show it in the sidebar.

    It does show it in the data model:

    Here you can see penaltyAt is 5 levels deep from Leagues.

    No need to create key fields. Let Ninox handle everything for you.

    • Mel_Charles
    • 3 mths ago
    • Reported - view

    Just to qualify what Fred says. unlike other software you don't need one filed to be a key field.

    Once you related one or more tables to each other. Then all data from the tables are linked! so you don't even need any ad hoc relationships along the way either.

Login to reply

Content aside

  • 3 mths agoLast active
  • 2Replies
  • 75Views
  • 3 Following