I have 2 DB blocks in my form. When I do any changes in the first block and save, it should always raise a message to ensure that at least 1 record is available in the second block. I wrote a code to count the no of records in block 2 and raise a message accordingly in Pre-Commit trigger at Form Level.
But this validation should not happen when I delete a record in the first block. ie. The validation should happen only while doing UPDATE..Kindly assist how to do this..