Determining the selected item from poplist

I've created a dynamically selected using create_group_from_query without problem. The list gets populated and displayed properly. The select to populate this is :

     select name, name from table_name;

Say the poplist is in block Reason and is caled Reason_Drop_Down -- Reason.Reason_Drop_Down.

My problem is refering to the item that was selected by the user.

What I did at first was simply assign the value to a variable like

    vNewReason := :Reason.Reason_Drop_Down;

and this returned the selected value the majority of the time. But if I went back & reselected, the value in vNewReason wouldn't always be set correctly.

So I started thinking I need to use the GET_GROUP_ functions to select the correct value. Am I barking up the right tree?

Because only one value could be selected, my thought was that I could use vSelectedItem := GET_GROUP_SELECTION('rg_reason_list',1);

   where rg_reason_list is the record group name and the 1 is for the 1st item selected

and from there get the actual value using

  vColumnName := Find_Column('rg_reason_list.name');   vSelectedReason := Get_Group_Char_Cell(vColumnName, vSelectedItem);

But this isn't working either. So I guess the question I have is :

What is the appropriate way to determine what was selected from a poplist?

Thanks much.

Donna Received on Wed Jul 28 1999 - 20:42:13 CEST