Details? Well, you asked for it. :)

People take trips all month long. Payments are also made during the month. At the end of the month, the trips and payments are gathered together into invoices.

I take the client balance table, and make a copy of it at the end of the month. When the user wants to run bills, I scan through the names in the balance table, set the index on the details table to that client's ID, and add a record to the cursor for each line in the details table. This record contains the info from details table, plus the balances from the balance table, plus the bill to address, plus the user's company address. That's in _each_ record.

I want to have two cursors. One is the invoice cursor. This will have the balances, billing company, and bill to address. The other will have all the details. How do I make the report writer show one record from the invoice cursor on each page and all the records from the details cursor?

I don't even know how to use two cursors in a report. If they were tables, I could put them in the data environment, but not with cursors that don't exist at design time. Right now, I set the work area to the cursor I want to use and run the report. It then uses that cursor. I can't set two different work areas.

Thanks,

-Michelle


>
>I´m not sure whether I get you, but you certainly can SET a RELATION from a cursor to another one; you just need to have the second one indexed. Also, you may need to use SET SKIP TO.
>
>If you can give more details, I´m willing to help.
>
>GL!