Set Root Table and Instance ID Column
How Do I Define the Root Table and Instance ID Column in an LU Schema?
Each LU schema must have a Root Table and Instance ID (Instance PK Column). The Instance ID is the unique identifier of each LU instance. When creating a Logical Unit using the Auto Discovery Wizard, the Root Table and the Instance ID column are defined according to the selected Root Table and column in the Wizard.
If you are not using the Auto Discovery Wizard, do the following:
- Go to Project Tree > Logical Unit > double click the schema > Logical Unit screen.
- Create the LU table and add it to the LU schema.
- Go to LU table > right click table header > Set as: Root:
- Double click LU table to open it.
- In the Table Properties, click Instance PK Column > select the table column defining the Main Identifier of the table.
Note that only one column can be defined as True in the Input Arguments of the Root Table. This field is populated by the Instance ID.
Set Root Table and Instance ID Column
How Do I Define the Root Table and Instance ID Column in an LU Schema?
Each LU schema must have a Root Table and Instance ID (Instance PK Column). The Instance ID is the unique identifier of each LU instance. When creating a Logical Unit using the Auto Discovery Wizard, the Root Table and the Instance ID column are defined according to the selected Root Table and column in the Wizard.
If you are not using the Auto Discovery Wizard, do the following:
- Go to Project Tree > Logical Unit > double click the schema > Logical Unit screen.
- Create the LU table and add it to the LU schema.
- Go to LU table > right click table header > Set as: Root:
- Double click LU table to open it.
- In the Table Properties, click Instance PK Column > select the table column defining the Main Identifier of the table.
Note that only one column can be defined as True in the Input Arguments of the Root Table. This field is populated by the Instance ID.
