How to make one field dependent on another
Hi All,
I have 2 fields say FieldA and FieldB which is dependent on FieldA.
The logic is If FieldA is NULL then FieldB should be NULL
If FieldA is not NULL then FieldB should be not NULL.
I have written the following code in the WHEN-VALIDATE-ITEM trigger of FieldA
if :BLOCK_NAME.FieldA is not null then
set_item_property('BLOCK_NAME.FieldB', REQUIRED, PROPERTY_TRUE);
end if;
This makes the FieldB mandatory (color changes to yellow) when I tab out of FieldA, but if I save the record without any value for FieldB, it gets saved without any errors.
Any help is appreciated.
EBS version 12.1.3 DB version 11.2.0.2 and Forms10g