Delete Global Customers

after the worksheet is created, before issued, you can add items to the worksheet_DelGlobalCustomers table of specific items to delete.

One way is to import a list of unrelated items using MS Access, but since the data already exists in the Customer table, it is easier to write a query to add the items based on some criteria that you want to delete, like:

insert into worksheet_delglobalcustomers (worksheetid,customerid,accountnumber,lastname,firstname,company) select (select max(id) from worksheet where style`1), id,accountnumber,lastname,firstname,company from customer where lastname='new customer' and totalsales=0 and address2+company+country+state+firstname+address+city+zip+title+ convert(varchar,notes)+emailaddress+taxnumber+phonenumber+faxnumber=''

this query marks all 'blank' customer records for deletion, but a more efficient way might be to use worksheet 51 instead to instruct the sql at the stores to directly delete from the customer table with your same criteria. (delete from customer where ...)

disclaimer: modify> Can anyone tell me if its possible to import into the 601 worksheet? I can