GDB “N-City” contains tables “Building Certificates” and “Reference of Streets”. The table “Building Certificates” contains the field of integer type “Street Code” unlike the table “List of Building Certificates” which has a string field “Street”. The table “Reference of Streets” has two fields: a unique field of integer type “Code” – the reference key and a string field “Name” – the reference value.
To set the table “Reference of Streets” as a reference for the field “Street Code” of the table “Building Certificates” the following sequence of actions should be performed:
open a browser window of the table “Building Certificates”;
select the field “Street Code”, perform the command Fields+Reference;
select the table “Reference of Streets” in the drop-down list “Reference table” of the opened dialog box “Setting reference for field …” (figure 27-1);
select the only field “Code” in the drop-down list “Key”;
select the only field “Name” in the drop-down list “Value” and push the button OK.
Figure 27-1. Dialog box “Setting reference for field”
It should be noted that if the table used as a reference has several fields, not all the table fields will be presented in the drop-down list “Key”, but only those which have the attribute “Unique” and which correspond to the type of the table field to which the table is set.
If you do not want to use the reference for a table field, the command Fields+Reference should be performed one more time for this field and the button Remove and then OK should be pushed in the opened dialog box “Setting reference for field”.
 |  |
