Hi all,

       I have a requirement where I need to prevent duplicate split records in Opportunity Split where each record added to the split table should have  qualification (picklist field with some qualifications listed) given only once . Any qualification should not be given twice to different team members and it should be prevented. 

      I started with trigger as it is the best way to solve this. I am having a tough time here since the each DML operation on Opportunity Splits run in seperate transactions and not able to figure out the duplicates. Did anyone face a similar issue and how we can approach this ?