How do I ensure for a unique record based on two field settings ?
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 ?