calculating fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using Office Professional 2003, and created two tables, one for
customers, the other for orders. The tables are used for for wedding flowers
arrangement, and each customer's order is entered only once, on a one-to- one
relation. The order table has several fields for the various flower
arrangements, these arrangement and prices vary with every customer. I tried
placing the flower arrangements, their unit prices, and the total for each
arrangement in a columnar display (left to right). I have not been able to
make it work. Can someone help me?
 
I would think you would need at least three tables....

Customers
Order
OrderDetails

Each "Order" might have multiple lines (records) of details.

You should look at the Northwinds sample database that comes with Access. I
just used that table structure this weekend to build a database to track
Mary Kay orders for my wife.

You end up with Customers as a one-to-many relationship to the Order table.
The Order table has a one-to-many relationship to the OrderDetails table.
Of course, there is another table that stores all the products and their
prices. This table is used as a lookup to create the entries in the
OrderDetails table.
 
Back
Top