Junction Object Record Uniqueness

Question

I have three objects. Accounts, Consortiums, Campuses and have set up a many to many relationship between Consortiums and Accounts. And also from Campuses and Accounts. I've done this by creating two junction objects that sit inbetween. This enables me to add more than one consortium to an account, and more than one account to a consortium. I am looking for ways to prevent duplicate records being created. Can I do this by validation rule, or will I need to write a trigger?

Martijn Schwarzer · Accepted Answer

Hi Glenn,

You will have to write an Apex Trigger for this purpose. On Master-Detail relationships you cannot set the Unique flag, and validation rules only look at the current record and not the other records in the database.

You will want to create a before insert trigger, that checks if there is already a record with the same values. If so, you add an error to the duplicate fields and therefore prevent saving the record to the database.

Hope this helps! If you need further assistance, please let me know. I'd be happy to help!

Best regards,

Martijn Schwärzer

Junction Object Record Uniqueness

Salesforce Developer

Aprendizagem relacionada

Mais ajuda