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