Included in D365, the edit query is a powerful tool that gives a visual representation of the database structure.

Select a primary table to enable the Query button at the top of the form.

Click this button to open the Inquiry pop-up window.

From here, you can filter the query for records, sort the query based on available fields, and join additional tables to the primary table.

When tables are joined, the associated fields are available for selection in the Query section and Data section on the Transaction Setup form.

Add Table

1. Select the Joins tab.
2. Click Add table join.
3. Select the table.
4. Click Select.