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

Preventing duplicate records on a junction object with 3 lookup fields.

I have two fields on a junction object that look up to the account object. One is called "Member Account" the other "Group Account". If Account A = Member Account, and Account B = Group Account then Account A shouldn't be able to be a Group Account if Account B is a Member Account.

 

I realise that I can't enforce this with a validation rule, so was thinking along the lines of creating another field, making it unique, and updating it with the values of two fields combined, but that probably won't work either.

 

Any ideas on how I can prevent this happening?
11 risposte
  1. Sunil Sarilla (M&G Investments)
    6 giu 2016, 18:17
    see the view from Account

     

    see the view from Account I have tried to create a new record under junction object and I receive the system validation message, please see the screenshot below

     

    I have tried to create a new record under junction object and I receive the system validation message, please see the screenshot below

     

    User-added image
Scrivi una risposta...
0/9000