I have a table and I need to prevent duplicate rows on insert and update. The stipulations are as follows:
*The field DeptID can never contain a duplicate.
*Other fields such as contact or requestor may/will have duplicate data
*Need to avoid duplicate rows due to hitting submit twice or anything else a user might do.
Thanks in advance.