to be able to bound a drop down list to SQL data, you need to turn on the option Show Dynamic Properties within the options settings of LiveCycle Designer
Tools > Options > Data Binding > Show Dynamic Properties
Then you can select a drop down list and bind items from data connections, just click the green text in the red square in the image below :
Once in the Dynamic Properties dialog, you have all the options you need!
Data Connection: Choose the data connection to have the field's list needed
Items : If Data Connection is selected, the field is disabled
Item Text : Specify what value is suppose to be displayed to the user
Item Value : Specify what value is to be used when using the property rawValue
Hope this help!
Hi Magus069, thank you for your help in this matter.
I am new to this and really I do not know how things work!
Do I have to make ODBC Microsoft Access set up for every PC in my office or the data will be somewhere saved in the network/server and from there everyone will pull the data??
How I can create the data? With what application?
Well the way I work it out, if the data is sensitive and can only be accessed by your organization, I put the database on a share drive where all user from that same organization can access it..
Therefore, you will need to set the data connection by default on each computer to be able to access to that database using the data sources of your windows...
Otherwise you can load the data from the database and save it on the form and treat the data afterwards without having to connect to the database...
Also, Reader doesn't connect to databases by default unless they have an option checked in the settings, so saving the data on the form will evade the issue of not being able to connect to database with reader, unless they all have acrobat pro that is not an issue