Yes, I have to use livecycle for manipulating the database connection. I created the forms in acrobat, (which are made up of several state regulatory forms), for the purpose of having a single, complex PDF that we can merge data into. This saves us time (several hours)from having to complete each form manually and also from having to use Word's mail merge.
I then added a record selector/menu to the first page. When a record is selected the data populates all 31 pages in the form. The state's agency has added another 5 page form that I need to now incorporate into this automation. I can import the pages into acrobat pro.
However, as I stated, when I go to designer to add the database fields to the new pages, the new pages are missing. When I switch back to Arobat, the new pages are there. ???