I am using Visual FoxPro 3.0.

I have a grid control with a child table in a SET RELATION style relationship (1-to-Many) as the rowsource, pretty standard really. How, if at all, can I order the records that appear in the grid? Since I can't set the order...that would mess up the relationship.

It seems like such a basic bit of functionality, but I can't figure out how it's possible without getting rid of the relation and using SET FILTER instead...and all the lousy performance that would entail.

Thanks,
Eric