Relations

When you have created a new table that is not being merged or consumed directly into Main Table but is required to update a status field for Workpack creation, you will need to build a relationship. The relationship will allow you to connect two data tables together.

In this example, we will create a relationship between the Main table and the Drawing Status. The connection in the table 1 (Main Table data) shows values in the IFC column that match up with the values in table 2 (Drawing Status data) Status column. This is the connection that we need to build in Relations tab.

"Step 0" "Step 0"

STEP 1:

Select the Main table in Data Tables and in the Properties table, select Relations tab.

"Step 1"

STEP 2:

Select the + icon to open the table.

"Step 2"

STEP 3:

Update the Child Table to the chosen table to connect and update the Description.

"Step 3"

STEP 4:

The Key Column is the row in the Main table that you need to match with the row in the Drawing Status – Foreign Key Column. Press OK.

"Step 4"

STEP 5:

Now we can create the connection in the Columns tab. Select the Columns tab and press the + icon.

"Step 5"

STEP 6:

Update Display Name and select Aggregation on Column Type.

"Step 6"

STEP 7:

Select Source Table and then the value to display and the Operation drop-down menu.

"Step 7"

STEP 8:

Press OK and you now have your value connected to update the status on every data refresh.

"Step 8"

STEP 9:

Repeat this step in the Staging selecting Main to bring in the Drawing Status as the source, with the same operation for the value. This will show the relation in the Control Panel staging table.

"Step 9"

Note: You can also build an Is Feasible from here using the Drawing Status as your dependency / constraint.