Consider a simple form. Two tables in the dataenvironment. The main
table has a list of children and what class number they are in. The
'subsiduary' table lists the class number and their teacher name.

Technically, the subsiduary table is actually the parent in a
one-to-many relationship.

The data entry on the form is simply a text box for the child's name,
and a combo box showing the teacher of that child.

Navigating through the records shows them listed in 'class number'
order. This is despite the fact that I have set the
InitialSelectedAlias to the children table, and have set the order to
the index on the childs name (primary key)*.

How can I get the records to display in the order I want, not the
order of the primary key of the 'praent' table?

Ben

* yes, I know - I'm not really using a name as a primary key; I'm just
trying to simplify my problem!