--This script fixes a Primary Key issue which was affecting the functionality of the PROMS Administrative Tools--

UPDATE tblItems
SET PreviousID = 1872778 -- or NULL if itemid = 1872778 is deleted
WHERE tblItems.ItemID = 1872779