Load a listbox from values selected from another listbox in Infopa

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David_W - 04 Apr 2006 16:43 GMT

I have multiple listboxes all of which are recieving data from a database.
What I would like to happen is that when a value from listbox is selected
then only the values which apply to the selection are loaded in the second
listbox. The results I keep getting is all possible values and not for the
ones that apply to my original selection. I have tried doing this multiple
ways and nothing seems to work. I have reworked the tables in the database,
changed the dataconnection around etc etc. Can this be done?

Reply to this Message

S.Y.M. Wong-A-Ton - 05 Apr 2006 11:21 GMT

Yes, it can be done. Have you tried adding a filter (through the Filter Data
button when setting up the data source for the list box) to the dependent
list boxes? The filter must compare the selected value in the main list box
to a corresponding field in the data source of the dependent list box.
---
S.Y.M. Wong-A-Ton

> I have multiple listboxes all of which are recieving data from a database.
> What I would like to happen is that when a value from listbox is selected
[quoted text clipped - 3 lines]
> ways and nothing seems to work. I have reworked the tables in the database,
> changed the dataconnection around etc etc. Can this be done?

Reply to this Message