Very Computer

1. Need help with data model - problem tracking product from many warehouse shelves

I have a problem modelling a database in Access 97.
I am trying to track a customer order.  
The order history must keep
- the order header
- the details of the order (each product ordered)
- the warehouse location (shelf) of the product at the time of the order

For now, I am pulling the information from the warehouse and storing the
order warehouse_location in the order_detail_warehouse_location table.
I am having trouble when the user wants to change the order - i.e.
modifiy
the quanity ordered.  On the form I want to see the quantity available -
which is stored in the warehouse_location table.

TABLES
warehouse_location - The shelves where products are stored.  Products
can
                     be stored on many shelves.  Products are nto always
                     stored on the same shelves.  The warehouse_location
                     data is updated daily from another source.  
product - the product data
order_header - the basic info about an order (customer, order# etc)
order-detail - each product on an order
order_detail_warehouse_location - where the warehouse location for the
                                  product is stored for historical
purposes

My question is: Can I redesign the model to better track the warehouse
shelf location of order details?

The model:

WAREHOUSE_LOCATION
      \|/
       |
       |
    PRODUCT
       |
       |
      /|\
  ORDER_DETAIL----< ORDER_DETAIL_WAREHOUSE_LOCATION
      \|/
       |
       |
 ORDER_HEADER

Thanks

DR

2. ADO + SQL Server problems when updating

3. SmartWare II v1.5 Data Manager File Format

4. Tracking changes for web app

5. A DATABASE SURVEY

6. Ca - San Diego $$$/Fast Track/Senior Oracle Apps Tech/Functional Analyst

7. must see IT links site

8. Looking for work tracking db app

9. Help needed! Real time app = problems with locks

10. Java track, database track, complete conference program for $50 (NEXTWARE Spring 2002)

11. OCP DBA O8i track vs O8 track

12. Bug Tracking or Call tracking package