This is not an easy think to do. The invoice ID's are created
by SQL Server on the fly. The only way to reset the counter
is to truncate the table. But you can't truncate a table that
has relationships. Therefore, to do this you would have to:
1. Remove all relationships to the invoices table (right click,
select show dependencies to list them).
Truncate Table Invoices
Truncate Table InvoiceItems
3. Re-create the above relationships you deleted.
-- Dale E. Reed Jr. (email@example.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.emerald.iea.com