Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi. How can i restrict contents of a list box based on the selection made in another list box. Say i have a list box with State names Ex: Karnataka, Andhra Pradesh, Rajasthan etc., and another list box with city names. If i select Karnataka in the first list box i should be getting only the cities in Karnataka state in the second list box. Any idea?
Hi
Click "Hide Excluded" on the list box properties; or select Expression in the Field list and enter the expression:
=Aggr(City, City)
(not the expression tab)
HTH
Jonathan
Hi
Click "Hide Excluded" on the list box properties; or select Expression in the Field list and enter the expression:
=Aggr(City, City)
(not the expression tab)
HTH
Jonathan
The problem you have stated requires the use of heirarchy.
Either you declare a heirarchy for the city - state or you can define a table with city and state as the column.
without defining a relationship between the city and state you will not be able to filter out the unselected cities from the listbox.
eg.
pfa sample