Defining Foreign Keys
The combination of primary keys and foreign key relationships determine the navigation through your web flow. That is, if your flow must have navigation from one region to another based upon the same object, a foreign key must be defined for that object.
Prerequisites
Define objects.
Define attributes.
Define object attributes.
Define Primary Key(s).
To define a foreign key:
1. In the Web Application Dictionary, navigate to the Foreign Keys window by choosing the Foreign Keys button from the Objects folder window.
2. Enter the foreign key.
3. Select the parent object (database view).
4. Enter the referenced key. This is the unique (or primary) key of the parent object.
5. Optionally, enter a description for the relationship.
6. Optionally, enter the inverse relationship.
7. Optionally, enter a description for the inverse relationship.
8. Enter the foreign key column.
9. Enter the referenced key column.
10. Repeat the last two steps until all referenced key columns have been assigned.
See Also
Defining Objects
Assigning Attributes to Objects
Defining Attributes
Defining Primary Keys