Got a copy of Fmp 9 - the best kept secret in the world. I've tried Access from MS which is a nightmare and very hard to learn.

I've set up my first database to track vehicles at work and it badly needs tweaking.

I have a pop down list of 7 vehicles on my form. Each time I fill out the monthly mileages I'd like to assign some unique info to each vehicle - such as registration, service dates etc.

I am having trouble visualising how to do this task - should I create separate value lists for each vehicle or a new table

Hope this is no too confusing

Cheers

Hi,

I would have (3) tables,

1- Vehicle table (information about each vehicle i.e. VehicleID, make, model, year, color, vin#, current license#,etc.),

2- Maintenance table (to record maintenance, key to vehicleID, date, type of service, milage at service, cost, provider of service, etc.) &

3- Milage table (Monthly milage record, key to VehicleID, date, current milage)

one vehicle has many maintenance records and milage records

Make the VehicleID field in the Vehicle table a serial number that is auto entered with no modification allowed. It should be for relationship use only, not printed or viewed by user, & void of meaning other than to connect the relationships.

HTH,

Tim