This is a very simple project for an experienced cold fusion programmer. Running into a small issue with an update query that I need assistance on.
First person to post a working updated query solution on PMB will be awarded this project, assuming your price is reasonable.
BRIEF:
We have an update query which is supposed to update two tables. However the second table it is updating is updating too many records instead of specific ones we need. See attached current pages for reference. Post any questions to PMB.
DETAILS:
This is for a dealership inventory system. The issue I am having though is basically dealing with two tables:
TABLE 1: VehicleModels: This is a reference / lookup table.
id, codemodel, model
TABLE 2: Vehicles: Contains the actual inventory
vid, model, make, etc....
In short, when we use our update form to update a VehicleModels record, on the process page it is supposed to do two things:
a. Update the single record in the VehicleModels table.
b. Query all Vehicles table records WHERE model = #form.codemodel# OR #form.model#
c. Update MULTIPLE records in [login to view URL] field, where it meets the criteria above.
Please review sample code and let me know if you have any questions.