I just don't see the practical application of this foreign key. What benefit does it provide? I'll add that this is a user created database and the user is not around to answer this question any more.

Slight modification to table structure:

create table fktest (

dept varchar(10) not null,

dps varchar(10) not null,

constraint [pkfktest] primary key clustered (dept,dps),

constraint [fktester] foreign key (dept, dps) references fktest (dept,dps)

) on [Primary]

insert into fktest

VALUES('FAN', '3553'),

('FAN', '3554'),

('HAMS', '00001'),

('HAMS', '0001'),

('HAMS', '0002'),

('HAMS', '0003'),

('HAMS', '1304'),

('HAMS', '1336'),

('HAMS', '1337'),

('HAMS', '1350'),

('HAMS', '1355'),

('HAMS', '1362'),

('HAMS', '1363'),

('HAMS', '3104'),

('HAMS', '3106'),

('HAMS', '3108'),

('HAMS', '3110'),

('HAMS', '3540'),

('HAMS', '3541'),

('HAMS', '3542'),

('HAMS', '3543'),

('HAMS', '3544'),

('HAMS', '3545'),

('HAMS', '3555'),

('HAMS', '6000'),

('HAMS', '6001'),

('HAMS', '6002'),

('HAMS', '6005'),

('HAMS', '6006'),

('HAMS', '6007'),

('HAMS', '6008'),

('HAMS', '6009'),

('HAMS', '6010'),

('HAMS', '6011'),

('HAMS', '6012'),

('HAMS', '6013'),

('HAMS', '6014'),

('HAMS', '6015'),

('HAMS', '6016'),

('HAMS', '6017'),

('HAMS', '6018'),

('HAMS', '6019'),

('HAMS', '6020'),

('HAMS', '6022'),

('HAMS', '6023'),

('HAMS', '6024'),

('HAMS', '6025'),

('HAMS', '6028'),

('HAMS', '6029'),

('HAMS', '6030')

SELECT * FROM fktest

drop table fktest