I made a dynamic PDF-form in Adobe Live Cycle which has 4 pages.
On each page there are 16 similar rows, each rows contains 3 different elements.
The first element is a text field, the second element is a Drop Down Menu and the third element is an EAN13-Barcode.
Once the user entered a valid code and ".exit" the text field the DropDown-Menu gets updated and only has specific choices depending on the value of the text field:
if(this.rawValue == "9H23")
if(this.rawValue == "xyz1")
EAN.rawValue = "1234567891011";
It might be a bit low tech, but i use in-form storage for some forms i have done. I have hidden text fields and built a dialog for updating the textfields within. I never need to modify the actual form in livecycle, i just save new information into it as needed.
With Acrobat Reader you cannot use data connections, however you can import text files. And since XFA forms are XML-based and XML files are technically just text files, you're can import XML-files into your form.
So in your form there is a default dataset called "data", which is located under xfa.datasets.data. This is where your form stores the data entered by the user. Below the node xfa.datasets you're able to create as many other datasets as you need to store data in your form like an embedded database.
xfa.datasets.loadXML(yourImportedXML, false, true); //Add a new dataset
So what you need is a XML file, that represents your database, a script to import that into your form and finally some scriptings or data bindings to the imported dataset to populate your fields.
thanks for your answer. I generate the dynamic PDF in Adobe's LiveCycle Designer. Then i save it as a dynamic PDF. Afterwards different users open it on their computers which only have Adobe Acrobat Reader. They fill out the form and than they print it with something what is called "Cute PDF-Writer", which generates the finished form as an static PDF document.
I also thought about connecting the PDF with the Database but i dont know if thats possible and how.
How do you generate the finished form? as it may be possible to merge it with a data file, therefore you could change the code so that it looks up that data file, and any time you need a change you just change the data file and re-release.