Fixed a few things;
Originally posted by Dirt_Diver:
Customers:
CustomerID (numeric identity column)
"a picture of them"
First Name
Last Name
Address
City
Zip
Phone
all orders ever placed > and the ability to see the products for each order <-- not stored on this table, this is calculated
a running Total of amount ever spent <-- not stored on this table, this is calculated
a running total of Discount amount <-- not stored on this table, this is calculated
Products:
ProductID
Name of product
Cost of Product
Fabric Color
|
Orders are split into 'Order Header' and 'Order Detail' - In order detail you store the order lines for each order. The header hold everything together, and links the orders back to the customer. For example;
OrderHeader
OrderNumber
CustomerID
OrderDate
Status
Paid
Quantity
Rate
Amount
Tax
Total
OrderDetail
OrderNumber
LineID
ProductID
Product Desc.
Quantity
Rate
Amount
Tax
Total
personalization info
personalization color
personalization style
You need to get the structure right before you think about designing forms etc. What I'll say is that it might be worth your while to look at a simple bookkeeping program, which will do all of this for you.
|
