Forced acct code uniqueness

How do we force a customer code to be unique? IE put a uniq constraint on that entry in the db (not as simple as it sounds I suspect) and then the system will never allow for a code to be used twice.

Ideally we’d want a way to force uppercase on characters too if there could be an option in the settings.

These are things needed to be able to use this system in conjunction with other external systems that would use the code as a foreign key.

MAN01 should only ever reference one customer and man01 should not be valid (assuming one selected this as restrictions we’d want to put). You could allow us to define a regex string for validating an insert or edit.

This subject is discussed in other topics. I am closing this one.