Adding my voice to this. I have a table of clients with a “client code” column where I’d like to enter a unique 3-letter code for each client. This is typed manually, but I need an alert if the code is already in use.