Create UNIQUE constraint

-- RecordNumber will now be a unique field

ALTER TABLE Clients
ADD CONSTRAINT UN_Clients_RecordNumber
UNIQUE (RecordNumber)

-- LocationID, PhoneNumber and StartDate will be unique per row

ALTER TABLE Clients
ADD CONSTRAINT UN_Clients
UNIQUE (LocationID, PhoneNumber, StartDate)