Import/Export to Access Database

[Former Community Member]

All,

I have a form that I want to pull a sequential number from an access database. This will populate a field on the form which is simply a unique sequential number. Then I fill out the various fields on my form and I want to export those values back to the database and place them in the same record as the sequential number. I have my form built and my database built. I have a data connection established and the form fields bound to the database fields. I found a tutorial by Stefan Cameron that was very helpful. Here is my question:



Now what? What mechanism/script, etc. do I use to cause the data to be transferred once I have my fields filled in?



Thanks,



Stan

[gkaiseril]

If he has provided sample forms, download them and look at the various scripts within the form, he provides very good comments.



Get additional LiveCycle Designer documentation:

http://www.adobe.com/devnet/livecycle/articles/lc_designer_scripting_basics.html



http://www.adobe.com/devnet/livecycle/designing_forms.html

Especially the

Providing interactive database lookup from forms (PDF, 612k)

http://www.adobe.com/devnet/livecycle/articles/lc_designer_db_lookup_tip.pdf



Search the samples folder at the top of this forum for database. processing samples.



You will be using JavaScript running on the client and passing SQL commands through the various "#command" methods.

[Former Community Member]

Geo,



Thanks for the links. The "purchase" example is helpful. One more question. This example populates a form based on the values in an access table. Can you point me to an example where I populate the fields in an access table from the data that resides in the form fields?



Thanks,



Stan