Back to this one:
I'm having trouble figuring out how to set up the filtered RS for the validations.
I have three fields on the form: brandName (a dynamic select field), productName (a text field), and bName (a hidden dynamic select to capture the brandName for the record insert). Record Insert is working properly.
How do I create a useful recordset for the server validation validation? If I understand the flow, the RS needs to be create on the POST, and the validation needs to occur after the RS is created. Do I create (or copy) the recordset code inside the code for the validation, or is there a simpler way??
Current page code attached - throws an error even though I try to insert a brandName/productName combo that I know doesn't exist..
Thanks,
mp