- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
re: Order Tracking Site or Program
Posted on 7/6/16 at 11:56 am to The Next
Posted on 7/6/16 at 11:56 am to The Next
When you're implementing query wizard be sure to include the following:
Orders
OrderNumber (PK)
CustomerID
IsShipped (boolean/bit)
Shipments
ShipmentID (PK)
ShipDate (date)
CarrierID (FK Carriers table)
Tracking
ShipmentID (FK Shipments table)
OrderNumber (FK Orders table)
TrackingNumber (PK)
(In the Tracking table, ShipmentID, OrderNumber, and TrackingNumber would make up the primary key/composite key).
Hopefully this helps in clarifying the basics using Access and RDBMS, whereas it can get way more complicated. It helps to practice it for organizational purposes.
Orders
OrderNumber (PK)
CustomerID
IsShipped (boolean/bit)
Shipments
ShipmentID (PK)
ShipDate (date)
CarrierID (FK Carriers table)
Tracking
ShipmentID (FK Shipments table)
OrderNumber (FK Orders table)
TrackingNumber (PK)
(In the Tracking table, ShipmentID, OrderNumber, and TrackingNumber would make up the primary key/composite key).
Hopefully this helps in clarifying the basics using Access and RDBMS, whereas it can get way more complicated. It helps to practice it for organizational purposes.
Back to top
Follow TigerDroppings for LSU Football News