AnsweredAssumed Answered

Enter Unique Multi Field Value

Question asked by laguna92651 on Sep 5, 2016
Latest reply on Sep 5, 2016 by 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

Outcomes