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

"dreyz" <dreyzachs_at_hotmail.com> wrote in message news:3VY89.190399$UU1.35394_at_sccrnsc03...
> How do I make a field non-editable (using the keyboard) but still allow
the
> user to select a value into it from a LOV ?
>
> 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
> 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.

If you set the property 'Validate from list' to Yes, a typed-in value is checked against the values in the LOV. If there's no match and the user tries to leave the item, the LOV is shown. Maybe this helps.

--
Joost Bataille
University of Amsterdam ICT centre