We have data entry screens which have date fields. If there is no date,
we require the data entry person to put a two char code in to explain
why there was no date. For example:
Date of Birth: __ __ /__ __ /__ __ code:__ __ Weight: __ __ __ . __
Here is what I want:
1) If there is a valid date entered, I want FORMS to skip over the code
field. If there is no date, I want FORMS to allow the user to enter the
code.
2) If the user goes past the code field, to the Weight field and presses
the KEY-PRVFLD, I want FORMS to go back to the Date of Birth Field,
bypassing the code field.
By brute force we can define a trigger for the code field:
ON-NEW-FIELD-INSTANCE and say:
if :A.DOB is not null then
next_field;
end if;
And also another trigger for the Weight field:
KEY-PRVFLD
go_field('DOB');
Is there a better way? I tried playing around with SYSTEM.CURRENT_FIELD,
but I could not find anything elegant. Since we have over 200 places
where we would like this done, we would like a more general solution
