Hi,

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

Store
Store_id(PK)
Store_site_id(FK)
Router number(unique key cant be the same)

Site
site_id(pk)
store_site

sure

ALTER TABLE Store
ADD UNIQUE ( Router )