>My Customer Table (Parent) and Customer_Order Table (Child)
>are related by a 1 to many relationship on Customer_ID (PK for Parent and FK for Child).
>Is it possible to view the records in the child table, on a 1 to many form, ordered by Order_Date without breaking the relation ?
>TIA.
Erdinc,
Make the index ion the child table have a key expression of;
Customer_ID + DTOS(Order_date)