Validate Item value in multiple records [message #600310] |
Mon, 04 November 2013 16:02 |
|
nrachovitsas
Messages: 2 Registered: November 2013 Location: Greece
|
Junior Member |
|
|
Hi all,
This is my first post in the form and also i'm new to oracle forms technology.
I have the following issue:
In my form i have two Text-Fields to store some information for a claim:
A --> Profit and
B --> Loss
(only one of the filed can have value)
Also i have a data block where i store the reason of the claim (status).
Reason can take three values 1, 2, 3.
For each claim i can have more than one reasons stored in db table.
Target solution
if the user input more than one reasons, then if one of them is 1 Profit should be set unprotected and Loss should be set to protected.
I have the following issue.
Scenario
user creates a records with reason 1 : Profit text field is set to unprotected and Loss text filed is set protected.
user creates another record with reason 2: Profit text field is set to Protected and Loss text filed is set to unprotected. --> wrong
How can i validate the values of the two records and create the desired functionality?
I have used the POST-TEXT-ITEM trigger but it works correct only for one record. i i insert two records with the above order i have the issue i describe.
Could anyone know how to fix this?
|
|
|
|
|
|