Avoid circular reference with configuration tables
You can solve this problem by either removing ProjectName from Inventory (since it is redundant because it is already specified in ProjectCategory), or enforce the relationship via a foreign key:

CREATE UNIQUE INDEX ON ProjectCategory (ProjectCategoryID, ProjectName);

ALTER TABLE Inventory ADD
  FOREIGN KEY (ProjectCategoryID, ProjectName) REFERENCES (ProjectCategoryID, ProjectName);