How to: Override displayed column for Lookup Field

Using the Lookup Field property it is simple to indicate which column should be used from the lookup selected within the control. By default, the customString1 field(Primary) is used.

1. Click on Modules.

2. Select the Module with the appropriate form field.

3. Select the Forms tab.

4. Select the Field List button "Create/Update Fields".

5. Use the filter to find the relevant field.

6. Select Edit on the field.

7. You will need to enter the internal name of the form field column from the lookup selected in the Lookup Field property.

   Open

   

    

8. To get the Internal lookup column field name, navigate to the SharedLookup tab and find the shared lookup that you want to use.

9. Click on the Form button for the Sharedlookup you are going to use

   Open

   

    

10. Once in the shared lookup form click on the Configure this Field wrench for the filed you want to use in your lookup field.

11. Select the Debug tab to get the Internal Name for your shared lookup – Lookup Field.