Hi,
Currently I'm working on a database that will track deliveries a company will make. The database will comprise of the following tables and their function:
- A Driver Table: This will contain information about the driver such as their name and contact details.
- A Products Table: This will contain a list of all the products the company will sell, including details about the product.
- A Vehicle Table: Including information such as the registration of the vehicle.
- A Deliveries Table: Detail information such as the driver assigned to the delivery, which products they will be delivering, the vehicle they are assigned to and will include the amount the driver will charge to make the delivery.
Would it be better I use the deliveries table or make a query instead, I do need to track the deliveries and then calculate the weekly charge I need to pay each driver.
Thanks,
Sunny
Currently I'm working on a database that will track deliveries a company will make. The database will comprise of the following tables and their function:
- A Driver Table: This will contain information about the driver such as their name and contact details.
- A Products Table: This will contain a list of all the products the company will sell, including details about the product.
- A Vehicle Table: Including information such as the registration of the vehicle.
- A Deliveries Table: Detail information such as the driver assigned to the delivery, which products they will be delivering, the vehicle they are assigned to and will include the amount the driver will charge to make the delivery.
Would it be better I use the deliveries table or make a query instead, I do need to track the deliveries and then calculate the weekly charge I need to pay each driver.
Thanks,
Sunny