Relationships.

[Guest]

Hi All,

At the moment I am designing a huge and sprawling database that hopes to
track products from the moment an order is placed to the moment that it is
received by the client.
I am finding that order_id from the orders table is everywhere, and am
unsure if this is good policy! Also, some areas are updated (i.e order
details and so forth) but others are not!! Any help or pointers to
informative sites would be greatly appreciated!

 

[Jeff Boyce]

Consider reading up on normalization, and check the example database that
comes with Access (Northwind). It has an order system.

If your entity/relationship diagram has multiple relationships with the
Order table, you'd need to have OrderID showing up for each of those.