Stuck on validation

[Kip]

I am stuck on validation.

I have different values that should be checked by a calculation.

For instance the values are:

bread

butter

cheese

flower

The calc should check if these values are unique. So it should not be possible to add this value twice:

bread

butter

cheese

bread

Does someone know how to fix this? Thank you so much!

[RalphL]

Use a self-relationship based on record serial number or other key field. Use the count function.