Define an ascending lookup table using formonly fields

  1. Open the form to be modified. A record of the form must include fields from the master table as well as the lookup field(s) from the reference (non master) table.
  2. Confirm the join between the tables. Right-click on the record and select Edit Query to confirm the join between the master and reference (non master) table.
  3. In the Form view, select the join field and in the Properties view change the fieldType to NON_DATABASE or COLUMN_LIKE.
  4. In the Records view, select the record field and navigate to the Properties view.
  5. Select the dropdown menu in the lookup field and select the join field described in the above step.

Save the project and execute the application. The ascending lookup table is created with formonly fields.