Xref: alice comp.databases.oracle.tools:35361
Path: alice!news-feed.fnsi.net!newsfeed.direct.ca!news.maxwell.syr.edu!newspeer.monmouth.com!nntp2.deja.com!nnrp1.deja.com!not-for-mail
From: pberetta@my-deja.com
Newsgroups: comp.databases.oracle.tools
Subject: Re: Help! Interdependent List Boxes
Date: Thu, 11 Nov 1999 00:23:45 GMT
Organization: Deja.com - Before you buy.
Lines: 46
Message-ID: <80d2ae$og0$1@nnrp1.deja.com>
References: <3829CA16.97DAC0B6@pilot.msu.edu>
X-Article-Creation-Date: Thu Nov 11 00:23:45 1999 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)
X-Http-Proxy: 1.1 x26.deja.com:80 (Squid/1.1.22) for client 208.242.203.214
X-MyDeja-Info: XMYDJUIDpberetta

I'm sure you've checked this already, but make sure the output of the
second record group is mapped properly in your LOV (only mention it
because I've done it).  Assuming this is not the problem, on to the
next question.  Do you want to base the values displayed in the second
list on the single value a user has already selected from the first
list, or on the entire contents of the first list?  If the first, a
global should work, if it doesn't, the trigger you are using to load it
may not be firing before you execute LIST_VALUES (a clue to this would
be, on first use list does not populate, on second use it populates
with values you expected the first time) or the data-types may be
different.  Does the select you are using in the record group work if
you run it from SQL*Plus in the form:
select col_x
from   rec_grp2_table
where  col_y = (select col_selected_by_list1
                from   rec_grp1_table
                where  col_selected_by_list1 = val_selected_from_list1)
;

If this doesn't run from the command line, figure out why.




In article <3829CA16.97DAC0B6@pilot.msu.edu>,
  haleysco@pilot.msu.edu 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
>
>


Sent via Deja.com http://www.deja.com/
Before you buy.