This did correct one table, but actually I gave you the wrong command.
Sorry.
Part of Emerald 2.2 is a new Database Consistency script. I just put
the
script up in /emerald/beta on the ftp site. Its called CheckDB.sql.
Run this script (your Database MUST be called Emerald for it to work)
and send me the results. I am mainly looking to see if it correct
an identity problem for your InvoiceItems table.
-- Dale E. Reed Jr. (daler@iea.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.emerald.iea.com