Snyc Fields

[pjscott]

I’m using sql 2000 and Access 2003. I have 2 tables Vehicle Request and
Vehicle Type which has 4 fields (LicenseNo, VehicleMake, VehicleModel and
VehicleType .

I have a Vehicle Request form with the requested info plus the 4 fields from
the Vehicle Type table. Once someone requests a vehicle our Maintenance
department assigns them a vehicle. I have a drop down box to select the
assigned License No. This works fine but when the License No is selected I
can’t get the data associated with the VehicleMake, VehicleModel and
VehicleType fields to snyc to the License No field.

What do I need to do to sync the data of the 4 fields?

Thanks for the help,

Paul

 

[John Vinson]

What do I need to do to sync the data of the 4 fields?

Why would you want to?

Storing the information redundantly in a second table is neither
necessary nor good design. Just use a Query to link by the drivers's
license number.

John W. Vinson[MVP]