Master table: [Orders]
Order ID Customer ID Employee ID Order Date Freight Ship Name Ship Country
10255 Richter Supermarkt Michael Holz Anne Dodsworth 7/12/1996 $148.33 Richter Supermarkt Switzerland
Back to Master table
Extra features on this page:
1. Total field
2. dependent dropdown boxes on the ADD/EDIT page
3. Lookup wizard as List page with search
order details
  Category ID Product ID Unit Price Quantity Discount
  Inline Edit View   Chang $15.20 20
  Inline Edit View   Pavlova $13.90 35
  Inline Edit View Dairy Products Gorgonzola Telino $12.50 2
  Inline Edit View   Inlagd Sill $15.20 25
  Inline Edit View   Raclette Courdavault $44.00 30
              Total: 112