Table Structuring

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.

Order Details
1. Customer ID
2. Product ID
3. Quantity

1. Product ID
2. Product Description
3. Unit Cost
4. Quantity On hand
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!