Hi my g/f asked me a question for a course she is taking on MS Access tonight and i could do it, i just need help structuring the table.
Create a database with 2 tables Order Details and Products. You need to create only 10 records in each table. There should be @ least 3 different customers ordering(each can order more than one product) out of the available (@ least 10) products.
The part that i get screwed up on is each customer can order more than one product, how are you sappose to do that without duplicating the Customer ID (As the primary Key) ? Any help would be great.
1. Customer ID
2. Product ID
1. Product ID
2. Product Description
3. Unit Cost
4. Quantity On hand