how to make LOV field non-editable but LOVable in Forms 6i

From: dreyz <dreyzachs_at_hotmail.com>
Date: Thu, 22 Aug 2002 03:30:07 GMT
Message-ID: <3VY89.190399$UU1.35394_at_sccrnsc03>

[Quoted] Hi Folks,

[Quoted] How do I make a field non-editable (using the keyboard) but still allow the [Quoted] user to select a value into it from a LOV ?

[Quoted] I have a table (emp) that has a foreign key (deptno) into another table (dept).
In my form I have a block which is based on emp. I want to show the dept name against each employee. Also while adding employees I want the user to be able to select a dept from a LOV.

I have

1) created a non database field in the emp block.
2) hidden the deptno field from the emp block.
3) Created a LOV that selects dept name and deptno from the dept table into

[Quoted] [Quoted] the the non database display field created above and the hidden deptno. 4) have attached the LOV to this non-db field.

But I do not wish to allow the user to type into this field. I want him to be able to only select from the LOV.

Any ideas ?

TIA.
Dreyz.
Sorry for the long post..... :P Received on Thu Aug 22 2002 - 05:30:07 CEST