Access Northwind.mdb: Cannot relate Customers to Orders tables

In the datasource frame, isn't the Orders table supposed to appear after the last (i.e., the Fax) node of the customers table. I tried deleting and re-creating the relation in the .xsd file. I tried making another app with a copy of the Northwind database. Northwind's database in Access appears to be uncorrupted. I get no error message. It's just that in the Datasource window I can't get the Orders table to come up as a subnode under the Customer's node. I really wanted this of course so that I could create a form where when you navigated to the next customer, the orders associated with that customer came up in a datagrid. I have the customers table defined in details format and of course have not been able to define the format of the orders table because it does not appear under the Customers node. Of course, I can drag the Orders table to the form but then it appears with no relation to the Customers table. I understood that the Orders table would appear under the Customers node as well as appearing as a top level node and that if you dragged the orders subnode (of the Customers node) to the form (after dragging the Customers table to the form) you would have an automatically created relation without code.

Any help or even a 'It's beyond me!' would be greatly appreciated!

pberkhof at 2007-8-21 >