Is there a way to automatically delete associated entries from the Price table when an item is deleted from Catalogue Items? In a test, the Catalogue Items totalled 9000, whereas there were 15000 entries in the Price table (which still held entries from deleted items).
Deleting these orphan entries would currently have to be a manual task (e.g. searching by a unique item identifier or mapping through a "marked for deletion" flag in a Delete field).
Any suggestions / ideas would be much appreciated.