To create a database query with related fields

  1. Log in to the Query Builder
  2. In the left pane of the Query Builder, locate the file needed for the query.
  3. Expand the file, then Relations, and then One-to-One or One-to-Many, depending on the type of related field you want to add to the query.
  4. Select the fields within One-to-One or One-to-Many, and add them to the query by double-clicking them individually or by clicking them individually and then right-clicking and selecting Select Field from the context menu.
  5. Add any other fields needed for the query.
  6. Click Execute to test the query.
  7. Save the query.
  8. To make the query available to your VB or other application, select the text of the query and then select Copy from the Edit menu to place your query on the Windows clipboard.