I have a pdf form that contains a table that I want to pre-populate with data from an Access 2003 database, before sending the form out to clients for them to fill in. The form is to be populated with data relevant to them, so for each client there will be different data and hence there own personalised pdf form.
In the form, the table contains one data row and a button to allow the user to add a new row and hence more data. In pre-populating the table for a client, there can be any number of rows and I would like each of the rows to be shown in the table, and for the client to still have the ability to add a new row for a new record.
In LifeCycle Designer, I've created and OLEDB Data Connection to the required Access table and I have bound each field in the table to a field in the data connection. There are also numerous text fields in the form that I want to pre-populate from Access.
When I display the form in Preview mode, all of the text fields are populated correctly but only the first record in the data connection's table is displayed in the form's table. How can I get all records in the data connections table to be displayed in the form?
After I populate the form I want to be able to save it as a new pdf and email it to the client so that he can check, and edit, the pre-populated entries, and also fill out additional fields and add new rows of data to the table if required.
When I test the pdf on a computer that does not have the Access database and the required ODBC datasource, ie. the clients computer, the form opens with an error message, correctly, stating that the ODBC datasource cannot be found. It then proceeds to open displaying the correct data in the various fields. How can I supress this error message?
I hope that I'm using the most appropriate method to achieve what I want to do.
Thanks for any help that you may be able to offer?