How to take form info, check a table, then write to another table or go back to form?
Posted on 2004-08-24
Now I have a new requirement to take the form information and check if 4 of the field's information matches an existing record on table2.
If the record matches, write the new record to table1.
If the record does not match with table2, go back to the form and give the user a message saying the record does not match on table2.
Could someone help with the code syntax for doing this, and maybe a simple example?