Stock control

[siuyan115]

Here are the tables I wanted:



Customer table:

Customer ID

Name

Address

Tel



Product table:

Product ID

Name

Supplier ID

Retail price

Selling Price



Supplier table:

Supplier ID

Name

Address

Tel



Order Table:

Invoice ID

Date

Customer ID

Product ID

Quantity

Total Price



The problem is in the order table. Within one order, a customer can
order many products, and each product can have different quantities.
So, can anyone help me?





I

 

[Kevin3NF]

You need an order details table as well...related back to the Orders table
via an OrderID (or Invoice ID). Product, Quantity, Price, etc should be
there...and "total" should be calculated, not stored in the table.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/Newsgroups

 

[Allen Browne]

To see an example of what Kevin is talking about, the Northwind sample
database usually installs with Access. Open it. Then choose Relationships
from the Tools menu to see how these tables work.

You can then look at the Orders form and its subform to see how to interface
them.