title: Duplicate error when updating cross-reference item
body: <p>When updating cross-reference items in Inventory, we get a duplicate key error. Looking into it, we discovered that when updating, the query does not filter by InventoryID only by SubItemID, AlternateID,AlternateType and BaccountID. This causes a problem when updating or deleting. Deleting a record will actually delete all items having the same subitemid, alternateid,alternatetype and baccountid but different InventoryID. Has this happened to anyone else? We are using version 5.1</p>