First, apologies for double posting this in the other Forms-Acrobat listing.
This forum may be more appropriate:
I am going to try to describe this as best I can, here we go.
I have a form designed in InDesign and made into a PDF.
I have an Access Database with 2 tables in it. One table contains “fixed” information stuff like addresses, names, numbers, etc with a unique ID of location_no. The other table contains the location number which matches to the 1st table along with 5 other columns of data per location number. In this 2nd table, there may be 10, 20, even 60 rows linked to one location_no from the 1st table.
Doing a data merge, I would like to merge information from the 1st table in the top part of the PDF form and merge the multiple data fields contained in the 2nd table to the same sheet where the location number matches
In addition, there are 5 columns side by side on the form on half the page and 5 columns side by side on the other half of the page. I would like this data from the 2nd table to fill in going down first, and then flow over to the 2nd page of the page where the 2nd set of 5 columns side by side is.
How on earth would I do this? I have tried VariForm PDF but cannot get the data in on the bottom half and I have even tried LiveCycle, creating a data connection within LiveCycle Designer and it populates correctly for the 1st record but how do I finish the merge, creating a PDF with multiple pages within based off the template with the corresponding data?
Thanks!
Erik
Any help is appreciated. Thanks.