I was wondering is it possible to ensure that their cant be duplicate fields on non primary fields? i can ensure that primary keys cant be duplicated but i was wondering can other fields be set so they cant be duplicated?
okay so for example:
i have a store table and a site table
Router number(unique key cant be the same)