Re: Help! Interdependent List Boxes

Here is how I deal with this situation:

In the WHEN-LIST-CHANGED trigger of the first list have:

if populate_group(<your_group_for_list2>) = 0 then   populate_list(<list2>, <your_group_for_list2>); end if;

In <your_group_for_list2> have a where clause which references :<your_block.list1>.

When the user changes list1 the record group will be re-built using the new value in list1. Then that new record group will be placed in list2.

The if statement around populate_group is required in case the query in your record group has aproblem.

If you need more info on this subject feel free to email me.

HTH
Geoff

Scott Haley wrote:

> I have a situation where I have two list boxes. The values in the
> second are dependent on the values in the first. I can't figure out how
> to set this up. Both List boxes are based on record groups. I tried to
> put a global variable in the where clause of the second boxes record
> group but it never works.
>
> If anyone has any ideas of how to do this seemingly trivial task I would
> greatly appreciate it.
>
> Thanks in advance,
> Scott
Received on Thu Nov 11 1999 - 02:43:59 CET