Hi all, 

  I have a usecase 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 ?

   Thanks in advance.