https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31568 Bug ID: 31568 Summary: Renaming/removing an authorised value does not cascade to linked tables Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: System Administration Assignee: koha-bugs@lists.koha-community.org Reporter: m.de.rooy@rijksmuseum.nl QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com We could give lots of examples here. E.g. location is controlled by category LOC having a value like CHILD. If you rename it to CHILDREN, your items still contain the old value. This cannot be solved with a FK since an authorised value may be in use under several AV categories. Maybe there are cases where you do not want to have an AV immediately cascade the change in a linked table? Also note that we have a maintenance script looking for these inconsistencies (bug 21466), but if we could reduce the volume here, I wouldnt mind. How should we best address this need? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.