While trying to combine 2 customers with Customer Number change I got a 127 Duplicate Keys error.  I ran DB Spy to find out what table this was occuring on. Turns out the error was ocurring on the ARSLCUS table.  Customer number change was trying to run the following statement when the error occurs:

UPDATE ARSLCUS SET "IDCUST"='CUSTOMER1' WHERE "IDCUST"='CUSTOMER2'

Obviously IDCUST is one of the key fields for that table and by updating CUSTOMER2 with CUSTOMER1 it's creating a Duplicate record.

So I have a couple of questions.  Is it OK to delete the CUSTOMER2 record from the ARSLCUS table?  What is the purpose of the ARSLCUS table?  Every record in that table has the exact same values(except for IDCUST).  Is that right?

Thanks

Accpac 5.5 (all the latest product updates)
SQL 2000
Windows 2003 Server

ARSLCUS is just a temporary selection list use for reporting, you can safely delete the "extra" record.