LinkedElement / FilterColumn / LinkColumn

There is a way to link fields together in the header. Using the linkedElement/filterColumn/linkColumn attributes.

Step-by-step guide - "filter"

Before using the filter function, you must setup the following in GetReferenceData

1. Write the table "MasterTable".
   
   
2. Write the table "SlaveTable".
   
   
3. In the header configure "Master" as:
   id = 5
   name = TestMaster
   inputType = List
   dataTable = MasterTable
   dataKeyColumn = MasterKey
   dataDisplayColumn = MasterName
   linkedElement = 6 - This points to the slave list.
   
   
4. In the header configure "Slave" as:
   id = 6
   name = TestSlave
   inputType = List
   dataTable = SlaveTable
   dataKeyColumn = SlaveKey
   dataDisplayColumn = SlaveName
   filterColumn = SlaveMasterKey    - This points to the column in SlaveTable to filter the values on.

Step-by-step guide - "linkColumn"

This method will change the value of another field when a specific field is changed.
The "Slave" field can be changed afterwards, but if "Master" is changed, the "Slave" will receive a new value.
Demo, in GetReferenceData do the following.

1. Write the table "MasterTable.
2. In the header configure "Master" as:
   id = 5
   name = TestMaster
   inputType = List
   dataTable = MasterTable
   dataKeyColumn = MasterKey
   dataDisplayColumn = MasterName
   linkedElement = 6 - This points to the slave field.
   linkColumn = MasterKey  - This is the value we want to be transfered to slave field
   
   
3. In the header configure "Slave" as:
   id = 6
   name = TestSlave
   inputType = Text

Whenever the "Master" field is change - the "Key" from the MasterTable is copied to the "Slave" field.

Tables used

For the examples, this data is used to demo the functionality.

MasterTable

The 2 tables are linked so the MasterTable.MasterKey --> SlaveTable.SlaveMasterKey

SlaveTable