Load a listbox from values selected from another listbox in Infopa

[David_W]

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?

 

[S.Y.M. Wong-A-Ton]

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.