This content has been marked as final. Show 6 replies
You already solved your question, but for future reference.1 person found this helpful
Did you generate this Form from Designer or are you working in Forms Builder?
- If you are working in Forms Builder then you could ask the question in the Forms forum Forms
- If you are working in designer you can also set a property on the LOV.
I generated it in Designer.
I was looking for such a property on my LoV itself, but couldn't find it. I don't see it on any tab, nor on the Advanced tab, so that's why I eventually used the set_parameter command.
Thanks for the reply.
Inside Designer, there's a Form Generator preference 'Validate Item in LOV (LOVVAL) that by default is set to 'Yes'
Help for this preference says:
Use this preference to specify whether the item is validated using an LOV.
If this preference is set to Yes, the LOV will be used to validate the item.
Note that validation using an LOV:
· is only available for allowable values that do not include ranges
· is not performed when a foreign key constraint is only validated in the server
Edited by: Johnreardon on Apr 12, 2012 2:08 AM
great, that was exactly what I needed.
I was looking in the properties of the LoV before, but didn't check the generator options of that title field. (I'm new to Designer)
Yes, I've always thought Designer generation is a bit strange in what is done in the generator preferences and what is done in properties. Doesn't always make sense.
The property sheets are at object (table, Module etc) level whereas the preferences are application level, so you can understand why they did it