Multiple values in one field??

[tjcinnamon]

I have a list of Vehicles in which each have their own maintanance schedules. Most of the maintanance for the Vehicles overlap. Instead of entering the same information over and over I'm assigning each type of vehicle a code number (example '05 Cargo is a 1, '04 Cargo is a 2). Now what I want to do is assign each maintanance the vehicle code, for instance I have 13 different types of vehicles that all need oil changes, so I want to assign the Oil change maintanance 13 codes. Is there a way to assign that maintanance 13 codes without having to enter it 13 times??

Thanks, Joe

 

[Pat Hartman]

I'm a little confused about where you are right now so I'll just tell you where you should be:

tblVehicle:
VehicleID (autonumber primary key)
VIN
Model
ModelYear
Manufacturer
etc.

tblMaintenanceCodes:
MaintenanceCodeID (autonumber primary key)
MaintDesc
etc.

tblVehicleMaintenance:
VehicleMaintenanceID (autonumber primary key)
VehicleID (foreign key to tblVehicle)
MaintenanceCodeID (foreign key to tblMaintenanceCodes)
MaintDate
etc.

It is possible that you will need more tables. For example, you may need to track the parts used for each Maintenance event.