Hi. If you don't mind, I do have a couple of questions about it.
That's it for now...
- What is the difference between Pick and Drop locations?
- In tblOrders, does EmployeeID refers to the person who took the order?
- Are drivers not considered as "employees?" If they are, how come they're not in the Employees table?
Pickup and Drop locations are 2 different geographical locations. Driver goes to the Pick location takes the load delivers to the Drop location.
Yes, EmployeeID is the person that who took the order.
Drivers are mainly contractors, but I was thinking of merging this 2 tables.