Hi Dallas,

> Is there a way to keep the pk/fk link but display the child grid in a different order.

You could use a compound index on STR(fk)+DTOS(date). If you use SET EXACT OFF and establish the relation on STR(pk) you still have the link between the two tables, but the child is sorted.