NIM

Specify 1-N relations

For more information, see 1-N intra-system relations.

  1. Expand a system's table list.

    2021-05-07_9-54-31.png
  2. Go to the table that will be the N side of the 1-N relation (i.e., the referencing table).

    For example, if you have a table of employees, each of whom has 1+ employments, go to the employments table. Or similarly, if you have a table of employments, each of which have 1+ contracts, go to the contracts table.

  3. Go to the table's Relations tab.

    2021-05-10_13-35-55.png
  4. There are two ways to specify 1-N relations: automatic (recommended) or manual.

    1. Automatic (recommended)

      1. Click Determine relations automatically.

      2. NIM automatically specifies 1-N relations for all parent tables whose primary key closely matches a foreign key in the referencing table. These relations appear in the Relations (1-N) pane.

        2021-05-10_13-36-48.png
    2. Manual

      1. Click a foreign key in the Column Navigation pane.

      2. The Match Score pane is populated with the match score of each possible parent table's primary key against the selected foreign key.

        2021-05-10_13-38-10.png
      3. Click 2021-05-10_13-18-57.png to add a 1-N relation. The relation appears in the Relations (1-N) pane.

        2021-05-10_13-39-42.png
      4. Repeat steps (i) - (iii) for each relevant foreign key.

  5. Click Save.

  6. Collect and load a system for this system.