Database table

The application database must contain a table that references both the master input fields and the slave 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 slave or master input field. The application uses this new table to select the records from the value that is entered in the master DBLookups and to properly display the associated values in the slave 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.