>>>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.
Have you considered using a Grid to show the child records? The grid sets the parent/child relationship and it's fast. If you want to EDIT the child records, just show the textboxes for each field and do a refresh in the InteractiveRowColChange method.
Barbara