Page Comparison

...

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.

Image Modified

Image Modified

Image Modified

Step-by-step guide - "linkColumn"

...

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

Image Modified

Image Modified

Image Modified

Tip
title AX
Example: this is used in Unplanned Move. Look a class Mob_GetReferenceData.addUnplannedMoveHeader(..) It is used to set "To warehouse" to the same value as "From warehouse", but the "To warehouse" can be changed afterwards.     Code Block language c# title Mob_GetReferenceData.addUnplannedMoveHeader(..) linenumbers true collapse true void addUnplannedMoveHeader(XmlElement linesElement) { // Warehouse to move from this.addDefaultWarehouseElement(linesElement, 1, #ReferenceDataTable_WarehouseList, #FromWarehouse, "@SYS25253", '2', #Warehouse_InventLocationId); // Warehouse to move to this.addDefaultWarehouseElement(linesElement, 2, #ReferenceDataTable_WarehouseList2, #ToWarehouse, "@SYS8519"); // Item number text box this.addDefaultItemNumberElement(linesElement, 3); }

...

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

MasterTable

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

SlaveTable

Related articles

...

...