Reset Filters

SmartList Builder 2018

Adding Additional Tables

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.
NLB Link Table

 

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.

NLB Link SQL Table

 

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.

NLB Link SQL Script

 

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.

NLB Link Extender

 

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.