-
Can someone help please?
I am trying to learn how to create a DB from scratch. I got a book at the library. Here's my issue. I am not getting very far and am limited on time. I am trying to create a simple DB to track trucks and trailers for a very small logistics company. Mileage, Fuel, Distance, Drivers. Can someone help me out with any ideas on how this should be set up? I currently have an excell sheet in which everything is tracked but it is too much.
-
You need to identify all the data that you're going to want to track. Offhand, I'd say a Trucks table with info about trucks, ditto Drivers, potentially ditto trailers. Then a transaction table with fields for truck, odometer, date, gallons, cost, etc. From that table mileage and such can be calculated.
-
you may want to consider hiring someone to set it up for you, but here are a couple of hints to get started:
table1 = list of drivers and their personal info
table 2 = list of the trucks in fleet. one to many relationship on table1 (driver) if there are drivers assigned to each truck
table3 = tasks/projects/trips (here you will store all information for a haul. one haul = one record. one to many relationship here on table1 AND table2. on the fields DRIVER from 1 and TRUCK assigned to the haul from 2.
-
I have tables created and test info in the tables but am not able to create queries or reports with the info I have in them. Is it possible that I have too many tables and or relationships?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules