Once a Referenced Table is defined, fields from this table can be added as index fields to a category. We will add it to the Quotes category that was created in Creating a New Category and then extended by Adding a Keyword Dictionary to a Category.
How do I add fields from a reference table?
1.Open the category and right-click on the dialog. Select the New Primary Field menu-item. This will display a sub menu of Referenced Tables. Select Employees.
![SD_T_Design_Data_Types_Adding_Data_Type_to_Category_001](./images/sd_t_design_data_types_adding_data_type_to_category_001.png)
2.The Properties window is displayed. Set the caption name as shown and accept default values for the other properties. Select the OK button.
![SD_T_Design_Data_Types_Adding_Data_Type_to_Category_002](./images/sd_t_design_data_types_adding_data_type_to_category_002.png)
3.After aligning the category will look similar to this.
![SD_T_Design_Data_Types_Adding_Data_Type_to_Category_003](./images/sd_t_design_data_types_adding_data_type_to_category_003.png)
4.Next we will add a field for Department. This is a dependent field which is linked to the Employee No. index field we have just created. Right-click on the dialog and choose New Dependent Field, then Employee No. and then Department.
![SD_T_Design_Data_Types_Adding_Data_Type_to_Category_004](./images/sd_t_design_data_types_adding_data_type_to_category_004.png)
5.Set the caption name as shown and accept default values for the other properties. Select the OK button.
![SD_T_Design_Data_Types_Adding_Data_Type_to_Category_005](./images/sd_t_design_data_types_adding_data_type_to_category_005.png)
6.After aligning the fields, the category should look similar to this.
![SD_T_Design_Data_Types_Adding_Data_Type_to_Category_006](./images/sd_t_design_data_types_adding_data_type_to_category_006.png)
|