Define queries and data order

Joins between tables referenced in the form are set up in the query property of the business record.

The Edit query dialog allows you to specify the joins between the tables in a record used for a form, report, or service.