Single and multiple rows

You can filter DBLookups that have only a single row that is available or multiple rows available.

A DBLookup with only one instance of itself on the page is a single row DBLookup. The Employee DBLookup on the Daily Timesheet Selection Parameters page is a single row DBLookup.

Multiple row DBLookups have more than one instance of itself on the page, such as the Job DBLookup on the Weekly Timesheet page.

DBLookup filters only work on a single page. This limitation means that the primary and secondary DBLookups must be on the same page. If you set up a filter between the Project DBLookup and the Job DBLookup on the Weekly Timesheet page, the filtering will not work on any other page in the application. The filtering will not work even on other pages where both DBLookups exist, such as the Daily Timesheet page. Each defined primary-secondary relationship is unique to the page on which the relationship is defined.