Data Modeling › Extending Relations › Sequence of Relations

Sequence of Relations

Before extending the Refers to relations for the HORSE file, you need to ensure that these two relations remain at the end of the relations for the HORSE file. The importance of this will become apparent later in the discussion of virtual fields.

Whenever the data model is reloaded, for example, when you press F5,CA 2E redisplays the relations in the following order:

• First, alphabetically by file name
• Then within each file in relation order, for example, Owned by before Known by before Refers to before Has
• Then by referenced objects in the order in which you entered them

You can override this order by entering sequence numbers to the relations in the Seq column on the Edit Database Relations panel.

You will type sequence numbers 10 to 70 so that the Refers to relations remain at the end of the list when the panel is reloaded. If you do not do this the two Refers to relations will be placed after the Known by relation instead.

Type the sequence numbers.

Press Enter.