I am attempting to make a dynamic form based upon a SQL 2008R2 database table. I need to have a data drop down list that populates from the database, and then when that list item is chosen, populate the remainder of the document fields from the database based upon that selection from the drop down list. I understand the drop down has to be bound to the data connection, but I am having trouble getting the list items to act like the documentation says they should. Here's what I have done thus far:
1. Under tools/options I have designated the data binding are to display dynamic content.
2. I have created a data connection to the database, and can see all database fields in the data view tab, and can also place those fields onto the document.
3.When I place the data drop down list onto the form, I indicate the list to be bound to the data connection I created previously, and the binding tab has this: '$record.DataConnection.databasefield".
4. From what I understand, the field tab, list items should be a green hyperlink, and it is not. I have no idea why, or how to accomplish what I need to do from here.
Am I asking too much of the software or am I missing something to make this happen. I have struggled with this for a few days now, and am about ready to move to something else for reporting. Can anyone assist?
I'm attempting to set up a PDF form with drop down fields referencing a SQL database. I'm having issues with LiveCycles "Data Drop Down List" connecting to my ODBC connector. The first value is shown in the field so I know my database connection is set up, however the drop down menu does not open.
I've found other resources online that describe Enabling "Show Dynamic Properties" and configuring the Data Binding. However the drop down list still does not open.
please advise me and share screenshot to done this.
Alright, but you're saying using a data drop down list.. I personally have tried a data drop down list to do what I needed with no success.
I prefer using a simple drop down list to do so.. but either one or the other should have List Items in green link with the option checked...
I would not want to mislead you anywhere, but when I had an issue with this the only solution I found was to check that option. Maybe there's another option you are missing or already checked out (can't be sure)
If you can, you could share your form I could take a look at it just to see if I can find anything unusual, but I can't assure you that I'll find something.