We have a database where we deal with car repairs.
We enter the customer name and then a dropdown list shows the Vehicle registration number, Make and Model. These are attached to the customer name (from table “Customers”) in the table “Vehicles”.
The VehicleReg is the primary key, so no duplicates!
However, sometimes these vehicles are bought and sold, and the new owner wants work done on the car, we to enter the Customer name on the form, then add the VehicleReg, and we have a problem adding this vehicle to the Customer, as it already exists in the database in prior jobs with the previous owner.
I’ve tried to set up, so that when the VehicleReg is duplicated, I can change the owner, but this keeps stalling and going round in circles.
Suggestions on a postcard please.
Stu
We enter the customer name and then a dropdown list shows the Vehicle registration number, Make and Model. These are attached to the customer name (from table “Customers”) in the table “Vehicles”.
The VehicleReg is the primary key, so no duplicates!
However, sometimes these vehicles are bought and sold, and the new owner wants work done on the car, we to enter the Customer name on the form, then add the VehicleReg, and we have a problem adding this vehicle to the Customer, as it already exists in the database in prior jobs with the previous owner.
I’ve tried to set up, so that when the VehicleReg is duplicated, I can change the owner, but this keeps stalling and going round in circles.
Suggestions on a postcard please.
Stu