Previous Topic: Specifying the Access Path DetailsNext Topic: Selecting the Access Path


Defining the Access Path Key

The objective for the resulting application is to give the end user the capability to view race results for a selected horse. The recommended order by which to retrieve the RACE ENTRY file is by Horse code, Race date, and Race time, with the most recent races retrieved first. Specify a key of Horse code followed by Race date (descending order) and Race time (descending order). Before you change the order, clear the numbers from the original key order.

Type the details as shown. In other words, blank the Key no. field for Course code and Entry number; type 2, 3, 1 in the Key no. field for Race date, Race time, and Horse code, respectively; and type D (descending order) in the Dsc column for Race date and Race time.

Press Enter to confirm the keys. Press F13 to return to the Edit File Details panel.