Answered
I create the database connection and then I create a drop-down box in my form. I go to the binding tab and select the database connection and then from the drop-down that appears I select the table I want. When I do a preview of my pdf form it only shows the first (I'm assuming) record in the table and I cannot use the drop-down to show a list. What am I doing wrong?
Normal Field binding, binds the Field's value to a data source. List entries are not the field's value, they are part of the field setup.
But there is a way, in fact, there are two ways to hook list entries into a data source. First, If you look on the object tab for drop down, the text "list items" just above where you enter list entries should look like a link. Click on this and it will display a dialog for binding the list items to a data source.
This method may not be suitable because of how the DB is structured.
The other method is to use the "Data DropDown" element from the "Custom" library tab. This is a regular drop-down that has some code on it for loading items from a DB. Read the instructions on the Initialize Script.
Thom Parker
The source for PDF Scripting Info
[url=http://www.pdfScripting.com]pdfscripting.com[/url]
The Acrobat JavaScript Reference, Use it Early and Often
[url=http://www.adobe.com/devnet/acrobat/]http://www.adobe.com/devnet/acrobat/[/url]
Thom Parker
The source for PDF Scripting Info
www.pdfscripting.com
Very Important - How to Debug Your Script