Creating/Defining Your Data Model › Defining Your Data Model › Redirecting Entries

Redirecting Entries

You can redirect entries resolved from a Qualified by relation or a Refers to relation.

Redirection of key fields resolved from a Qualified by relation provides a central mechanism for indicating to functions that when records are to be retrieved from a file to satisfy a relation, the retrieval is to be done on the basis of a nearest match rather than an exact match. For instance, you would use the prices in effect on a given date to price an order on that date for each product.

Retrieval may be done on a basis of nearest less than or nearest greater than depending on the value specified for the Sharing field.

The entry to be redirected must be sequenced after the relation entry that provides the source field for the redirection. You can specify sequence numbers on the Edit Database Relations panel to override the default order of relations.

Never redirect relations that are lower or move these relations so they are lower. If relations are not sequenced properly and you select a field for redirection, the selection will not take effect.

For more information on relation sequencing, see the chapter Creating/Defining Your Data Model.

The following discussion covers the two types of redirection: redirection of qualifier fields and redirection of key fields.