Yeah. Its gets messy.
Update CallHistory Set ChargeID = NULL
GO
Update InvoiceItems Set PaymentID = NULL
GO
Delete From Payments
GO
Delete From Charges
GO
Delete From InvoiceItems
GO
Delete From invoices
Go
> >You would have to delete them manually. The easiest way to delete them
> >is via isql_w:
> >
> >delete from InvoiceItems
> >Go
> >Delete from invoices
> >go
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com