Retrieve form data from database

[Jaminj]

Hello. I have a form that submits to a database and e-mails someone at the corporate office to let them know the form was completed. The e-mail would contain a unique field from the form (i.e. SSN #). I would then like the person who received the e-mail to be able to go to a web page to retrieve the form based on the unique value (i.e. they could input the unique value and the form would populate w/ all of the data). Any help would be appreciated.

 

[ca8msm]

On you form where the user enters the data, you would just pass a sql query through to the database, and while reading the results, enter the users data to the relevant textboxes/labels etc on the form. e.g. faq855-5662

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.

 

[Jaminj]

Would this work in the following scenario: The user would fill out 1 field and click retrieve. The form would then populate w/ all other values that are in the same row from the db.

 

[ca8msm]

Yes, it could do.

--------------------------------------------------------------------------------------------------------------------------------------------

Need help finding an answer?

Try the search facility (

http://www.tek-tips.com/search.cfm)

or read FAQ222-2244 on how to get better results.