>>>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.
>
>>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.
>
>Actually, that's exactly what I'm doing. I can get the records to display extremely quickly using relations, but now how do I set the sort order?
>
>-Gino
Gino: If you use the relationships set into the data properties for the grid, you don't need to explicitly set filters. I use an index for the child table that has the parent ID + the fields I want to sort on. For example, if I'm showing a list of names for each company, I index the name table on CompanyID + upper(last+first). Names neatly arranged.