How can I (is there a way to...) sort on a field in the detail table of a master-detail combination that is NOT the field used to define the master-detail relationship?!?!
Specifically, I'm using a Guests table (each record identified by a unique Guest ID), and an Orders table (each record containing the Guest ID of the Guest who ordered something as well as the Item # of the item ordered). I want to display the items ordered by a specific guest, but want to SORT them based on the Item # field (of the Orders table).
Oh... D4 with Access tables, all fields mentioned above have indices.