Lets say, I have 2 tables in database: APP.dbf and WORKHIST.dbf related on SSN. SSN in unique index in APP and regular in WORKHIST. Relation works fine on all forms, but I need to order child records from WORKHIST by entrydate and not by the SSN. If I try to change order of child table, my relation is not working properly.
So my question: Is there a way to order child table involved in replationship with parent table in any other order but relational expression. (And i mean without creating view or sorting).
Thank you....