This discussion is archived
2 Replies Latest reply: Jan 21, 2013 3:20 AM by hokoba RSS

Pre-Commit Form Level

hokoba Newbie
Currently Being Moderated
Dear Techies,

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..

Thanks and Regards
Sri

Edited by: hokoba on Jan 21, 2013 1:18 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points