The Year and Model Form Elements pass the needed information to get the unique info for the selected vehicle.
Create the following recordset:
SELECT model.*, basevehicle.*, make.*
FROM basevehicle INNER JOIN Make ON basevehicle.MakeID = Make.makeID INNER JOIN Model ON basevehicle.ModelID = Model.ModelID
WHERE model.ModelID = paramModel AND basevehicle.YearID = paramYear
In the Parameters section, add the following parameters:
Name: paramModel
type: Integer
Default Value: -1
run Time Value: $_POST['Model']
Name: paramYear
type: Integer
Default Value: -1
Run Time Value: $_POST['Year']
