Data To/From Database

[Former Community Member]

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

[Former Community Member]

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.

[Former Community Member]

email is bherbert@imcu.com



Thanks

[Former Community Member]

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

[Former Community Member]

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

[Former Community Member]

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



bherbert@imcu.com



Thanks,

Brad

[Former Community Member]

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