asp server side validation
Ive got a web form to enter codes, which updates a table in a database. The field it's updating is linked to another table, which has a table of all the codes, and therefore the code being entered has to exist in the table of codes.
If I enter in the form a code that doesnt exist in the other table, I get this message, which is understandable.
How would I go about making sure that what is entered in the form is a valid code in the code table?
[Microsoft][ODBC Microsoft Access Driver] You cannot add or change a record because a related record is required in table 'codes'.
Would I do another query on the update page, and then compare the data from the form to the recordset from the new query or something like that?