3 Replies Latest reply on Mar 12, 2013 2:51 PM by philmodjunk

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

    PecCars

      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 ?