is you value at first column in the lov list, which is match form the list of values.
what is this
"is you value" ?
"is match form" ?
i did not understand you .
let say you have a field empno and you have assign lov to this field with Validate from list = Yes.
Now LOV should have first column empno, ename or sal etc
then it will solve your problem and don't open the Lov for a valid list of values
I have a field and assigned a lov to it with "validate from list" = yes ,
the lov has a column for the field , and about 4 columns ,
each column returns it's value in an item , except one does not have a return item .
what is wrong with this ?
even when i enter a correct value , it appears when i try to go out from the item ??
i do not want it to appear if i write a correct value
Value you enter in a field is match with which column of the lov 1, 2, 3 or 4th one?
in order to avoid this problem, value you enter in a field should match with 1st column in LOV.
As I mention in my last post
user enter empno in a field and empno is the first column in lov, therefore, in case of valid value LOV not appear. If empno is after the first column in lov list then even enter valid empno, lov would appear.
1 person found this helpful
The "validate from list"-property causes a validation of the entered item-value against the values of the first column shown in the lov. If there is no match the LoV is shown. If there is more than one match, the LoV is also shown.