Hello all,

I have the need to print to Excel from VFP, the data source is a one to many (Parent on one line and the Child under it). I am having a problem putting the child under the parent, if the parent does not have a child print the next record. Example

Number Date Description of Transaction Debit (-) Credit (+) Balance
(Parent)
1404020001 12/20/04 Bank Deposit $1,000.00 $1,000.00
(Multiple Child)
1404020001 12/30/04 Transfer to VN $323.78 $676.22
1404020001 1/22/05 Paid to Family $500.00 $176.22
1404020001 1/3/05 Paid to Tom Jones $176.22 $0.00

Any help is appreciated!