>>>Greetings... Does anyone know how to change the order of a child table in a one-to-many relationship without destroying the relation?
>>
>>if you need to see something else in the child table, why not USE...AGAIN?
>
>I'm not actually trying to see something ELSE in the child table, but I'm using a relation to 'filter' out records in a very large table. I want these records displayed in a different order. Unfortunately, SET FILTER TO is just too slow. Any help would be greatly appreciated.
Set filter to slow?? If you have the filter based on a Rushmore optimizable statment, set filter is as fast as any other Rushmore optimized function. Unless you are doing string searches, which can't be optimized ( $ functions) then create a tag for the expressions and use set filter.