Form validation against SQL Database

[bouellet]

Any suggestions on how I can validate an ASP form field against a SQL data base. I simply want to validate the field value to ensure it is an existing item in my data base. I would like to do this as the field loses focus.

Thanks!

[Jerry Grant]

I think you will have to create client side DHTML script with an open database object. This however is not very secure, allowing the dishonest into your database directly.
Keep all your data access and validation in server side script (or in server bound ActiveX DLL components), by validating after the page is submitted, and sending back the page with a meaningfull message prompting for corrections.