hi ,
I have a form with one block based on "Defeciencies" table (item_id not on canvas ,item_name,...) .
Item_name has a lov with this query
Select item_id from items
Where item_id not in (select item_id from deficiencies)
And "validate from list"=yes
The problem is
If I insert an item_id into deficiencies table
Then try to execute query , I face error
"Invalid value for item_name"
I noticed that "validate from list=yes" is causing this
It validates the item_name I query and it shows error because the item I query is in "deficiencies" table and the lov says do not retrieve items which resides in deficiencies table .