Mass Delete

Steve:

Each item has a unique ID called the primary key even though you may have entered all of the other > Some how I have created multiple listings for the same item. I think I made

Steve, also keep in mind if you have activity in your database for any of these items, deleting them may cause some problems as the itemid for the deleted items are stored in other tables throughout the database when you use them on a purchase order, sales transaction, physical inventory, etc.... Deleting these items in this case will leave behind orphan records in these tables

hth kev> Steve:

Tom, I use this query with items that have been created incorrectly, but what I find is that I can not delete from the actual Matrix Name. I hate all of the ZZ's that we have had to create because of the persons involved with creating the items. Do you know of anything to remove Matrix Names?

Thank you.

Jocelyn

"Terrible Tom" wrote: