Home > Administrator Download RBT v1.3.1

Foreign Keys

The RBT Administrator allows a user to create pseudo foreign key definitions to define database table relationships not formally defined with database foreign key constraints. This capability provides a flexible mechanism to create SQL relationships that can be used in the Designer as a basis for SQL join statement generation. constraints.

Adding a Foreign Key Definition

From the Foreign Keys pane, click the green plus sign on the foreign keys pane to display the Add foreignKey pane:

add a custom relationship

Complete the Foreign Key Name entry. Click the add table icons to display the Select Table pane and select the desired primary and foreign tables.

select related tables

completed add foreign key pane

Adding Foreign Key Column Mapping

After completing the entries in the Add foreignKey pane, click on the Columns link to display the Add/Remove Columns pane. Click the green plus sign to create a new column mapping entry. Click the Foreign Column add column icon to display the Column Selection pane. Select the desired foreign and primary columns.To remove a column mapping click the delete icon. .

add related table columns

select related table columns

Editing a Foreign Key

From the Foreign Keys pane, click on the pencil next to the foreign name to edit the foreign key. See the Adding a Foreign Key Definition section above for full description. To delete a foreignKey click the red

edit custom relationship