I would like to have an alert when I input one value in a field and if that value already exists in another field, I would like to see one alert with "This value already exists! Please review the record". But I would like to keep a repeating value if I choose to, so I should not use the Unique Value.
Any ideas to solve this?
Many thanks for your help and time.
With my best regards,