AGI Security GVASBOX-100 - Manual (Page 124)

116
5. In the left side of the mapping field dialog box, select the field(s) of the source database
corresponding to the Name field of the GV-ASManager database. Then click Add. In this
example (Figure 12-9), the Contact ID field of the source database corresponds to the
Name filed of the GV-ASManager database.
6. If the field of the source database, without having the data entered, is linked to an index
or another table, click the Set Foreign Key button. This dialog box appears.
Figure 12-10
7. When the foreign key dialog box is open, the linked Primary Key Table and Primary
Key Field should be displayed if the connection of the Foreign Key Table and Primary
Key Table has been created. Otherwise, use the drop-down lists to select the Primary
Key Table and Field.
8. In the left side of the foreign key dialog box, select the field(s) of the Primary Key Table
corresponding to the field of the Foreign Key Table. In this example (Figure 12-10), the
Contact ID field of “Human Resource (Employee)” Foreign Key Table is linked to the
First Name, Middle Name and Last Name fields of “Person (Contact)” Primary Key
Table.
9. Click OK. In the Mapping Setting window, you can see the mapping results. In the
example (Figure 12-8), the Name field of the GV-ASManager database is mapped to the
Contact ID field of the source database which includes First Name, Middle Name and
Last Name (which are linked from the Primary Key Table).