Saving to and collecting data from a database

[normynorms]

I am working on  a small project where 3 forms need to interact with each other. Form 1 should be completed then the information saved to a database then form 2 called and because of common fields between the 2 forms...data should be populated from the database to form 2 (data that was entered from form1).

How is this done? Whats the javascript solution for this issue? the code used to save information from a text field, combobox and to retrieve it to populate another?

Thanks in advance

[Ben_Walsh]

This is typically implemented as a LiveCycle orchestration:

1. Form 1 is completed and submitted to a LiveCycle orchestration on the server
   
2. The orchestration saves the submitted data to the database and then uses it to pre-populate Form 2
3. Form 2 is sent to the user

Common options for these steps include:

1. Submission by email using a LiveCycle email end-point or secure, seamless submission by HTTPS to a web component (e.g. servlet or ASP.NET page) that calls the orchestration as a web service using the LiveCycle SOAP end-point
2. Form Pre-population is performed using Forms Data Integration (FDI) or LiveCycle Forms
3. Form is sent to user either by email or streamed back in same session if using HTTPS

Avoka Technologies provides a pre-built web component Process Invoker that makes it easy to implement the HTTPS submission option.

Of course, if the forms are filled out by the same user, you could merge them into one form and collect all the data on the client side before submitting to the server. You can even use show/hide to give the user the experience of filling out multiple forms if that is desired.

Ben Walsh

www.avoka.com