For this example we assume that the external database table Employees is a View in our Thereforeā¢ database.
How do I create a new reference table?
1.The table needs to be in the Thereforeā¢ database. Typically this is done by creating a view on the external database. Or, for Thereforeā¢ systems where the Thereforeā¢ server cannot access the external database (e.g. Thereforeā¢ Online), this can be done using Table Replication.
2.Right-click on Referenced Tables and select New Referenced Table...

3.Enter Employees for the Referenced Table Name. Select the Employees database table from the Table Name (or View) drop-down list. Select EmployeeNo as the Unique Identifier. Note: any column from the view can be selected, but it must be unique.

|