Re: Dynamic LOV's ???

Real simple, when creating your LOV in the query use the bind variable.

For example for your second query:

Select state, City from table2 where
country = nvl(:form.country, country);

This will allow to see a full list of State & Cities if there is no country selected in your previous field.

This will work fine on multi-record blocks. We do this all the time.

If you need more information, you can contact me directly.

HTH Prasad Chavali
pchavali_at_assettech.com
Ed Jennings wrote in message <3553579C.50B_at_domain-tech.com>...
>I'm using FORMS 4.5 on an NT platform. I have a series of
>4 List Items. The first List Item is populated via a
>Record Group when the Form is opened. The remaining 3
>List Items need to have their Lists created dynamically
>based on the selected values of the previous List Items.
>i.e. After selecting a value for List Item 1, List Item 2
>now needs to contain a subset of values that are restricted
>by the value of List Item 1. After selecting a value for List
>Item 2, List Item 3 now needs to contain a subset of values
>that are restricted by the value of List Items 1 & 2.
>
>For example, if you were selecting criteria for a map, the first
>item (country) would contain all countries. Once a country
>was selected, the second item (state), should contain a list
>of only the states within the selected country. Likewise, the
>next item (city), should contain a list of only the cities within
>the selected country and state.
>
>And to make it just a bit more complicated; these items are
>in a detail block that displays three records at a time. I
>don't want the other items to become invalid because the List
>changed. I'd rather that each record could be changed without
>any impact to the others. Think of it as a lookup table with
>multiple attributes. It will be queries and then updated in place.
>
>Can anyone provide some guidance on how this can be done????
>
>TIA
>
>Ed Jennings
>
>--
>The opinions expressed here are my own, not those of Domain Technologies
Received on Sat May 09 1998 - 01:36:01 CEST