Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Populate Dropdown List with Database Table Values

Avatar

Level 2

Hi,

I would like to dynamically populate a dropdown list, with values taken from a database table using SQL query.

The database connection is working fine, the query only pulls one field from the table.

But it either displays only the first value from the table and not able to expand the dropdown "down arrow" or says

"Don't Tell about this long description" (Yes, exactly like this, weird statement as the first/only value in the list)

I have the dynamic bindings on for the dropdown list.But it still doesnt poulate the list.

The xdp set as interactive form....

Can somebody tell me if I am missing something ???

Thanks

Ds

5 Replies

Avatar

Level 10

I have never seen that before ...is that coming from the DB? Can you post your form to LiveCycle8@gmail.com so I can have a look?

paul

Avatar

Level 2

No the value is off a database, could you please let me know

How to expand the listbox, to view the rest of the values.

Thanks

Eshwari

Avatar

Level 10

I can't tell you how to make the listbox populate unless I see the form to see what is wrong with it.

Paul

Avatar

Level 2

Hi,

You can find a sample file from the link below. I have used ms access tables as db. It is also a good sample to create dynamically populated related dropdown lists...

Enjoy,

Murat

http://muratkuru.com.tr/?p=84