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.