Msg 1776, Level 16, State 0, Line 41
There are no primary or candidate keys in the referenced table 'IssueProgress' that match the referencing column list in the foreign key 'FK_IssueLog'.

CREATE TABLE IssueProgress (
  Progress_ID int NOT NULL IDENTITY,
  ItemNo int NOT NULL,
  ProgressDate date NOT NULL,
  ActionDesc text NOT NULL,   
  CONSTRAINT PK_IssueProgress PRIMARY KEY NONCLUSTERED ([Progress_ID], [ItemNo]),
  UNIQUE (Progress_ID)  
);


CREATE TABLE IssueLog (
  ItemNo int NOT NULL IDENTITY PRIMARY KEY,
  ProjectCode int NOT NULL,
  RespRaisedDate date NOT NULL,
  Lname varchar(255) NOT NULL,
  Fname varchar(255) NOT NULL,
  MobileNum varchar(15) DEFAULT NULL,
  Email varchar(255) DEFAULT NULL,
  RespDesc text NOT NULL,
  SupportDoc image,
  Resp_Cat_ID int NOT NULL DEFAULT '1',
  Personnel_ID int NOT NULL DEFAULT '1',
  Ori_Target_Finish_Date date DEFAULT NULL,
  Rev_Target_Finish_Date date DEFAULT NULL,
  Actual_Finish_Date date DEFAULT NULL,
  Approval_Date date DEFAULT NULL,   
  UNIQUE (ItemNo),
  CONSTRAINT FK_IssueLog FOREIGN KEY (ItemNo) 
    REFERENCES IssueProgress (ItemNo) 
    ON UPDATE CASCADE
    ON DELETE CASCADE      
);