AnsweredAssumed Answered

How do I ensure for a unique record based on two field settings ?

Question asked by PecCars on Mar 11, 2013
Latest reply on Mar 12, 2013 by philmodjunk

Title

How do I ensure for a unique record based on two field settings ?

Post

      

     Consider the table Cost with the fields Date, Type, Value. There should be one single record per Date and Type. If I set Date as Unique and Type as Unique then it does not combine both fields to allow only for one specific Date and Type. 

     I tried creating a calculation field based on Date + Type, but a calculation does not allow for a unique value option.

     Can you advise how to implement this ?

Outcomes