I've to retire two training items and these are also part of a role that will no longer exist. The curriculum for this role should be made unavailable. for audit purposes the history of the curricula need to be available.
One option is to create a new field that essentially will archive the curriculum (or Record) in question. You can use a checkbox or a text-multiple choice field. Call it Archive? or make the options "Active" and "Archive" (or "Discontinued").
Then apply filtering to exclude any record that has the checkbox checked, or the option of "Archived" (whichever you end up using).
If this is not what you are looking for, let me know and provide any more details about the relationships in your application and where this information is used.