After you have created a query, you will arrive in the setup wizard. Here you can adjust all the settings of the query.
If you want to change the settings of an existing query, select the query in the query overview, and then click the 'Setup Wizard' button. Then you can follow the steps below.
- The first window again shows the basic settings that you entered when creating the query; you can change them if necessary. Click Next.
- In this step, you select the tables that should be part of the query. Select the table(s) containing the data you want to export, and click Add. Since in this example we want to export contacts for all suppliers, we select the table 'VendorContacts'. Because we also want to add some extra information about the supplier to the export, we also include the table 'Vendors'.
The tables in the left column are all available tables, and the tables shown in the right column are the tables you add to the query.
- Click Next to proceed to the next step.