Database table

The application database must contain a table that references both the primary input fields and the secondary input field. If the database does not contain such a table, you must create the table before you can configure DBLookup filtering.

This new table creates a relationship between two or more existing tables, with each table containing a secondary or primary input field. The application uses this new table to select the records from the value that is entered in the primary DBLookups and to properly display the associated values in the secondary DBLookup.

Using the previous example where the Job DBLookup is filtered by the value in the Project DBLookup, if you enter Project 1 in the Project DBLookup, the application uses this new table to select the job records that are associated with Project 1 and display them in the Job DBLookup.

You create tables by working with a database administrator to design the table structures and create the table.