>I have 2 tables related with a 1 to many relationship. I am displaying the child table's records in a grid. Is there a way to control the order of the child records shown in the grid? Whenever I change the order (SET ORDER TO TAG XXX), the relationship is dropped and everything goes nuts.
>
>Thanks for any comments or suggestions,
>
Chris,
You need an index that has the foreign key first in its expression adn then the sort key you want. For example assume the foreign key is CustID and the sort order desired is InvDate, your index expression would be;
INDEX ON CustID + DTOS(InvDate) TAG Whatever
The expression for the relationship must be first in the key.