Optional record and a required field. What should I do?
What do I do in a situation like this?
There is a multi-record black with a LOV button to select a value.
The item IS required (not null).
A record is NOT required.
When I set the item property Required to "Yes". When there is no record I get "FRM-40202: Field must be entered" error. Using the clear or delete key does not help. (When I set the item item property Required to "No", it tries to insert with the null field.)
In effect I have to enter at least one record even though it is not required.
I tried setting Defer Required Enforcement, it did not help.
Thanks.