2 Replies Latest reply on Sep 5, 2016 9:31 PM by laguna92651

    Enter Unique Multi Field Value

    laguna92651

      Just want to make sure I'm taking the correct approach. I only want to allow entry of an unique year for every ID_ACCOUNT. I created a concatenated column, UNIQUE_VALUE, that I set up with Validation as 1) unique value and 2) no override.

      The  table would have these values. Is this the way I should set it up?

       

      ID_ACCOUNTYEARUNIQUE_VALUE
      ACT012015ACT01_2015
      ACT012014ACT01_2014
      ACT012013ACT01_2013
      ACT022014ACT02_2014
      ACT022013ACT02_2013
      ACT022012ACT02_2013