- 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 8:46 am to LSURoss
Posted on 7/6/16 at 8:46 am to LSURoss
I could do excel but it doesn't give the functionality she would really need. She also has a desktop folder that is completely unorganized so I'm trying to give her the ability to upload files and have it automatically be organized and easily accessible through the program. I've set up access databases and I know I can do what I need with it. I just don't have the web programming knowledge (yet, at least) to allow her to enter the orders from her phone.
Handshake looks promising but I'm really looking to keep her costs down as much as we can.
Handshake looks promising but I'm really looking to keep her costs down as much as we can.
Posted on 7/6/16 at 11:47 am to The Next
So I always try to design a system that can allow for me to track shipments with relative ease when using Access.
Here is my basic criteria/constraints before converting to SQL:
1. Each shipment must have at least one tracking number (depending on the carrier, each package will have its own tracking number so a shipment very well could have multiple tracking numbers associated).
2. For truck carriers, they use one tracking number for a shipment. A shipment can consist of multiple orders (this is part of my problem).
3. Once used, tracking numbers cannot be repeated
4. Once an order is shipped, it cannot be shipped again
Here is my basic criteria/constraints before converting to SQL:
1. Each shipment must have at least one tracking number (depending on the carrier, each package will have its own tracking number so a shipment very well could have multiple tracking numbers associated).
2. For truck carriers, they use one tracking number for a shipment. A shipment can consist of multiple orders (this is part of my problem).
3. Once used, tracking numbers cannot be repeated
4. Once an order is shipped, it cannot be shipped again
This post was edited on 7/6/16 at 12:00 pm
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.
Posted on 7/6/16 at 1:14 pm to The Next
Check out smartsheet.com as well. It's an online project management SaaS platform that's user friendly. You can import existing excel files to coordinate orders placed on the consumer end and easier to use instead of Access. It has a free trial to see if it'll work out for your needs.
Popular
Back to top
Follow TigerDroppings for LSU Football News