Skip to Content
Former Member
Aug 09, 2007 at 02:01 PM

Delete entries in the Price qualified lookup table


Hi everyone,

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.