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.
|
