Re: Dev 2000 Forms ? part 2

Lets assume that the listitem name is COUNTRY and is in block WHERE. You would access the value in the WHEN-LIST-CHANGED trigger as follows:

value := :WHERE.COUNTRY;

to populate the second list box based on the first I would create a record group (RG_STATES) that just references :WHERE.COUNTRY in the where clause:

select state
  from world
 where country=:WHERE.COUNTRY

then in the WHEN-LIST-CHANGED trigger for the COUNTRY listitem: populate_group('RG_STATES');
populate_list('WHERE.STATES','RG_STATES');

something like this should work.

Elizabeth S Boese wrote:
>
> Hi again,
> this is Personal Dev 2000t trial software release 1.2
> Problems with forms
>
> 3) I have a drop down list on the form, and i want to know
> what the value of it is on POST-CHANGE or the similar
> such that when a user changes their choice, I can
> update another drop down list based on that choice.
> i.e.
> choices: US Central Am. Europe
> origianlly the second group of choices based on US
> would be: NY, NJ, PA, CO, UT, TX, etc.
> when the user changes the first drop down box s.t.
> Central Am. is showing, the
> second group of choices would then change to:
>
> Costa Rica, Mexico, Belize, Ecudor, etc.
>
> FIRST Problem: I don't know how to get the value in the
> first drop-down list ( GET_LIST_ELEMENT_VALUE didn't
> work. If this is what i need to use, let me know
> an example and I can try it again.)
>
> I'll wait on teh Second problem =)
>
> Pls r.s.v.p via e-mail to me =) mouchos gracious!
> liz.boese_at_ey.com
>
> ***********************************
> *\o Liz Sugar Boese
> *_| liz.boese_at_ey.com
> */ www.smeal.psu.edu/~boese
> *
> *
> ***********************************
 

-- 
robert
The statements and opinions expressed here
are my own and do not necessarily represent
those of my employer.