Creating DBLookups for customer-defined data

This example demonstrates how to create a custom DBLookup field in the Job maintenance form. This field allows users to select one record from the Cost_Center custom lookup data type, which has an ID of 10004.

  1. Open Config mode.
  2. Select Maintenance > Labor Metrics > Job.
  3. Click Edit for any job in the table.
  4. Click the edit control for Value 1.
  5. Select DBLookupUI from the FieldUI drop-down.
  6. In the Field Parameters field, specify this text:
    source="SELECT WCLD.WBCLD_ID, WCLD.WBCLD_NAME, WCLD.WBCLD_DESC FROM WB_CUSTOM_LOOKUP_DATA WCLD WHERE WCLD.WBCLDT_ID=10004"  sourceType="SQL"
  7. Click Save.
  8. Close Config mode and clear the application cache.
The DBLookup is created in the Job maintenance form. Users can select one of the records for Cost_Center when they create or edit jobs.