Open navigation

Advanced Queries

These settings affect database queries.

Database Installation - Advanced Queries

Pretty Print Column Names

Switch this option on to show meaningful column descriptions, if defined, instead of actual database field names.

Table Lookups

Allows you to define a relationship between one of your custom fields and a field in one of the standard tables, so the user can choose values from a drop-down list when running a query. Press Add or Modify to show the Query Lookup form, then choose the standard (link) tables and field names, the custom (lookup) table and field names and the field to be displayed. Press Delete to remove the highlighted table lookup.

See Custom Tables And Lookups for more information.

See also: File - Browser Query, Queries

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 -