Skip to main content
Topics#Data ManagementDomanda di Glenn Daly
Glenn Daly (Pod Point) ha fatto una domanda in #Data Management
24 mar 2016, 10:45

Junction Object Duplicate Handling

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.
1 risposta
  1. Pragadeesh R K (NTT DATA)
    24 mar 2016, 18:30
    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
Scrivi una risposta...
0/9000