Data To/From Database

Avatar

08-09-2008

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

Replies

Avatar

Avatar

pguerett

Avatar

pguerett

pguerett

08-09-2008

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.

Avatar

08-09-2008

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

Avatar

Avatar

pguerett

Avatar

pguerett

pguerett

08-09-2008

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

Avatar

09-09-2008

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



bherbert@imcu.com



Thanks,

Brad

Avatar

Avatar

pguerett

Avatar

pguerett

pguerett

09-09-2008

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