Today , I will be discussing about one of the common issue which we might face while showing fields from multiple tables in lookup . As we all know SysTableLookup only pick up fields from first data source. However, in few cases we might need to show fields from multiple tables for instance I need to show operating unit number but as well as organization hierarchy Name which is field of 4th data source within my custom. In order to achieve this target I will be using SysMultiTableLookup class.

Below is the code snippet.

Note: In below line the number 4 is showing the number of datasource n in my case it is 4th datasource.
 sysMultiTableLookup.addLookupField(fieldNum(OMHierarchyType, Name),4);



















Final output