Form server-side validation question

[Jeff]

I have a FP generated form within an ASP page.

The form submits data directly into an Access database. Does anyone know how
to validate a form field entry by comparing to existing data within the
database?

I have some equipment that gets signed out to employees and I would like a
validation to check to see if the equipment was signed back in.

Jeff

 

[p c]

You will need to do it in code (ASP). Here's the concept.

Myform.html submits to MyFormResponse.asp. In MyFormResponse.asp you
grab the data you want to check from the DB and then you compare with
the appropriate data submitted by the form. If the eq. is reported as
available, you submit the form data to the DB and update the eq. to not
available. If the eq. was reported as not available, you say "Sorry..
blah blah."

...PC