Re: Help with database design
You could start with a table to hold records of your vehicles,
You'd have fields like ID, make, model, rego_number, date_purchased etc, etc, etc.
You could have another tabel for fuel expenses, with fields like ID, car_ID, price, odometer_reading, date. The car_ID field is obtained from the first table.
Then another table for maintenance, with ID, car_ID, repair_description, value, odometer_reading, date.
Another table could be drivers, with ID, name, employee number.
The driver ID field could be added to the first table if you like, to track who's driving the car,
You could select all the expenses for a particular vehicle from all your various expanse tables, based on ID from the first table, or all the maintenance expenses for all cars, whatever you want.
Over to you!!
Good luck,
Barry.