Data To/From Database

[#1]

I know that there is a way to do this just can find the best way. I want my employees to be able to key in an account number and the database return necessary information. There will be 6 or 7 fields that will populate. I have created an ODBC connection to the source. After the form is complete I want my employees to be able to hit the submit by email button and the form be emailed as well as saved back to a different Database.



Thanks

Brad

[#2]

If you post your email address I will send you a sample of how to do the population part.



You will need to set the delayed opening on the DB connection and then control all aspects the data connection through script.

[#3]

email is bherbert@imcu.com



Thanks

[#4]

I cant seem to figure out the proper scripting for that. Do you have an example? I want to write it to a SQL Database.



Thanks

[#5]

You will have to create an empty record first ...then do an update to add your values.

[#6]

Did you get a chance to send me the email with the example script?



bherbert@imcu.com



Thanks,

Brad

[#7]

Sorry it slipped my mind ....just sent it