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.
--
Christof