You can add more than one table to a Navigation List by selecting an additional table and linking it to another table in the Navigation List.
To add an additional Microsoft Dynamics GP table:
1. | Select Microsoft Dynamics GP Table from the Add button above the Tables list to open the Add Table window. |
2. | Select the Product, Series and Table. |
3. | Select the table that you want to link to. |
4. | Select the link method. Use the Equals method if a record exists in both tables. Use the Left Outer method if a record may not exist in the new table. |
5. | Select fields to link the tables with. |
6. | Click Save. It will take a few seconds while the fields for the table are initialized with default settings. |
To add an additional SQL Server table:
1. | Select SQL Server Table from the Add button above the Tables list to open the Add SQL Table window. |
2. | Select the Database and Table. Select the Views option to display views contained in the selected Database. |
3. | Select the table that you want to link to. |
4. | Select the link method. Use the Equals method if a record exists in both tables. Use the Left Outer method if a record may not exist in the new table. |
5. | Select fields to link the tables with. |
6. | Click Save. It will take a few seconds while the fields for the table are initialized with default settings. |
To add an additional SQL Script table:
1. | Select SQL Script from the Add button above the Tables list to open the Add SQL Table window. |
2. | Enter the SQL select statement for the table. |
3. | Select the table that you want to link to. |
4. | Select the link method. Use the Equals method if a record exists in both tables. Use the Left Outer method if a record may not exist in the new table. |
5. | Select fields to link the tables with. |
6. | Click Save. It will take a few seconds while the fields for the table are initialized with default settings. |
To add an additional Extender Resource:
1. | Select Extender Resource from the Add button above the Tables list to open the Add Table window. |
2. | Select the Extender Resource Type. |
3. | Select the name of the Extender object. |
4. | Select the table that you want to link to. |
5. | Select the link method. Use the Equals method if a record exists in both tables. Use the Left Outer method if a record may not exist in the new table. |
6. | Select fields to link the tables with. |
7. | Click Save. It will take a few seconds while the fields for the table are initialized with default settings. |