I have a list of Projects. As they are completed I want to delete the item (or tag it as completed). The Project Library looks up "Project Name" from the list of Projects (so that it is easy to find in the drop down). But if I delete the Project from the list it removes that metadata from the Project Library item.
I can't use third party solutions or Designer.