• Siddy
  • 0 Points
  • Member since 2011

  • Chatter
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
  • 0

I have a Master - Detail Relationship. I dont want duplicate records in Master field. I placed a trigger (insert, update) which doesn't allow duplicate entry into the database.

Now when i update the detail field the trigger on master gets executed and it prevents me to insert data displaying that the record that i am entering is duplicate. I inferred that the update trigger gets executed even when i am entering detail record values. I dont want this to happen.

Can anyone suggest a solution of how to prevent the trigger from executing when i am entering data in the detail field.
  • August 11, 2011
  • Like
  • 0