Define Foreign Key Relationships

Notes:  

• This task requires previous experience working with databases. Ask your technical staff for help if necessary.

• A  foreign key is any key located in any of the tables in the database from which you are importing data. All tables containing data that are imported into UPS WorldShip database must be accessible through the primary table. Paths to this data are defined by creating links between the keys in the tables. These links are called relationships.

• You can only define relationships in ODBC databases that contain at least two tables.

• Prerequisite:  Create at least one 32-bit ODBC data source. See Administrative Tools in the Microsoft Control Panel.

To define foreign key relationships:

1. Create an import map. See Create an Import Map.

2. In the Edit Import Map window, click the Define Foreign Key Relationships button. The Edit Relationships for <map name> Import Map window appears.

3. Make the first field relationship:

4. Select a table under Relate From and then select a column name in the lower-left pane.

5. Select a table under Relate To that contains the corresponding field and then select the corresponding column name in the lower-right pane under Relate To.

6. Click the Add Relationship button. A appears beside each field. Also, a new line displays in the What You Have Related So Far box that shows both sides of the link.

4. Repeat step 3 for each foreign key relationship you want to include in the import map.

5. Make any necessary adjustments to the import map.

6. To remove a foreign key relationship, select both sides of the link and then click the Remove Relationship button. Any symbols are removed from those fields.

7. To quickly display both sides of a foreign key relationship, scroll through the What You Have Related So Far box and select the relationship you want to see. The Relate From and Relate To boxes display both sides of that foreign key relationship.

8. To sort the entries in the tables by column, click a column title, and the entries are sorted by that column. A small arrow shows how the column is currently sorted. An up arrow indicates ascending alphabetic or numeric order; a down arrow indicates descending alphabetic or numeric order.

6. When you have defined all foreign key relationships, click the OK button. WorldShip saves the foreign key relationships, and the Edit Import Map window appears.