Hi Peter,
The general idea is to produce a report having 2 details from 2 entirely different cursors or tables.
Suppose I have table1 that has records pertaining to the subcomponents of a particular package.
Then I have table2 that has records of services rendered for the particular package.
In the report, I want it to be displayed on the ff: format.
SERVICE SUMMARY REPORT
-------------------------------------------------------------
Package: Personal computer SERIAL NO. MK2-W238-123
Sub-Components && This comes from the 1st cursor
1. Monitor
2. Hardisk
3. CD-ROM
4. Floppy Disk
5. etc...
Service Rendered && This comes from the second cursor
1. Repair on CD-ROM
2. Format Hard Disk
3. Reinstall OS
------------------Nothing Follows-----------------------------
Music Rocks
www.musicreserve.blogspot.comSuccess is 1% Inspiration & 99% Perspiration
God Sometimes Delays His Help to Test Our Faith and Energize Our Prayers
Our Boat May Be Tossed While He Sleeps, But He Wakes Up Before it Sinks.