Hi there,

Is there a way to order a child table in a relation other than the the
"ordering" index in a parent/child relation? This is only for displaying in
a grid or a browse window...

I have established a relation with the parent ID into the child ID with the
command:

Use PARENT In 0 Alias PARENT Order ID
Use CHILD In 0 Alias CHILD Order ID

Select PARENT
Set Relation To ID Into CHILD

The only way I can display on a grid the records on the child ID that match
the ID of the parent ID is to ORDER THE CHILD BY THE TAG "ID". I have
another field within the child that is a DATE field that is also indexed on
DATE. However if I change the order of the child table to other than the
ordering index "ID", the grid wil not display any records. This is
convenient when I need to resort the information to the DATE field of the
child... Anybody have a solution to this problem??

Thanks,
Mark