Setting the options for a calculation field
I want to make one of my calculation fields a unique value, but I can't find the dialogue box to do so because the calculation dialogue comes up everytime.
Change your field type to that of a data field (number, text, date, time...) instead of Calculation.
Then you can double click it to open field options--which don't apply to calculation fields, where you can select the calculation option on the auto-file tab (you'll find your calculation has been preserved and will appear automatically when you select that check box). And now you can select the unique value validation option.
It worked. Thanks!
Retrieving data ...