Display Fields

Advanced Find - Display Fields

This form is the same as the Master Tool Settings form Database Settings - Queries - Display Fields.

Decide how the query results are to be shown by choosing one of:

  • Show the fields used for displaying projects - that is, your usual Project Browser fields
  • Show the following fields in this order - choose from the list; you can add New items to the list and Edit existing ones (via the Database Field form); Delete existing ones or use the up and down arrows to change the order of the highlighted item

When specifying a list of display columns you can also add lookup columns for LAYERS and any extra layer tables if you have added search criteria for those tables.

This example shows a list of display columns for DRAWINGS and CUSTOMER as well as lookup columns from both these tables.

You don't have to explicitly add a criterion from a lookup table to add a display column from that table. You just have to add a criterion for the child table to be able to use any lookups for it. So, for example, to use a LAYERS table relationship you just need to add a criterion containing the LAYERS table, to use a ONE_UP table relationship you need to add a criterion containing the ONE_UP table.

This example shows a query that includes ONE_UP criteria, so the list of display columns can include lookups from LAYERS and/or ONE_UP as required.

Note the use of the SALESREP table multiple times; it has lookups from DRAWINGS, LAYERS and ONE_UP.


Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

You may like to read -