I think I need to explain this a little more. Right now, I'm taking all the details and the balances and sticking them into one cursor. This means that every record in the cursor contains the balances, the bill to address, the company address, etc.

I'm wondering if there's a way to have two cursors in the report. One would be the master cursor for the invoice, one would contain all the details of the invoice. Can that be done?

Thanks,

-Michelle



>For billing, I have two tables. One is essentially an invoice details table, the other is a list of clients and their balances. Right now I go through a complicated mess of scanning and inserting into a cursor to get the cursor to print the invoices. I keep thinking there has to be a better way of going about this, but I'm coming up empty. Any thoughts?
>
>Thanks,
>
>-Michelle