combo box as lov

Respected Sir,

this is the situation::

SQL> desc const;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 IDATE                                              DATE
 ITM                                                VARCHAR2(50)
 AMNT                                               NUMBER
 DET                                                VARCHAR2(100)

I design a form and take itm as combo box. the objective behind this is that i want to populate itm values whenever i am inserting a new record, the itm value can be selected from already inserted values by querying the database. i write this code

**i check this code by putting it in when-new-form-instance,when-mouse-double-click and when-new-itm-instance triggers one by one but same problem**

declare
q varchar2(30);
w recordgroup;
begin
q:=get_item_property('itm',item_name);
w:=find_group('e');
if id_null(w) then
w:=create_group_from_query('e',
'SELECT distinct(itm),TO_CHAR(1) FROM const ORDER BY itm');
end if;
if populate_group(w)=0 then
populate_list('itm',w);
end if;
copy(get_list_element_value('itm',1),'itm');
end;

code complies successfully but when i enter the itm field one value is selected by firing the trigger and this is the first value resulted by above query(" SELECT distinct(itm),TO_CHAR(1) FROM const ORDER BY itm"). if i change this value by drop down the list then "1" is inserted in the database.

can any one solve this problem

in simple i want this combo box work as like list of values(LOV).....

thanksStart Free Trial