I am using apex 4.1.1 11gr2 oc4j Linux.
I want to set a validation on 3 items as such if one is not not null then other two must have values.
For example my three items are Dl year , DL# and Dl state(lov)
If the state is select then DLyear and dl# cannot be null .
If DLyear is entered the DLstate and dl# can't be null
If dl# is enter and other two can't be null.
If there a way to implement this logic before form performs the update / insert.
page level validation
Function returning Boolean
return ( DL_YEAR IS NULL and DL_STATE IS NULL and DL_# IS NULL )
or ( DL_YEAR IS NOT NULL and DL_STATE IS NOT NULL and DL_# IS NOT NULL);