How can I create an MS/Access Database (mdb) with 2 tables: Client and Order. A Client can have multiple orders and an order can have only one Client.
a. The Client Table contains a Client ID and a Full Name.
b. The Order Table contains an Order ID and a Description.
c. Both the Client ID and the Order ID are auto number fields. When the information is saved to the database then these auto number fields should contain the correct value which is assigned by the database.