Junction Object Duplicate Handling

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. 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? I'm hoping it's going to be a validation rule as I'm an admin and am not very familiar with triggers.

Pragadeesh R K · Answer

Validation rule - This functionality is meant to verify the data entered in the current screen and i dont think we can able to do a cross check with existing data in the data base.

I think you can play with updating a unique custom field value so system could do a Unique check on its own.

All the Best!

Prag

Junction Object Duplicate Handling

Data Management

Verwandte Lerninhalte

Weitere Hilfe