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...
![SD_T_Design_Data_Types_Creating_New_Data_Type_001](./images/sd_t_design_data_types_creating_new_data_type_001.png)
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.
![SD_T_Design_Data_Types_Creating_New_Data_Type_002](./images/sd_t_design_data_types_creating_new_data_type_002.png)
|