B
banker123
I have the following data in a file.
123456 Johns Account
10.00 Apples 10/08/2006
20.00 Grapes 10/07/2006
987654 Bobs Account
10.00 Oranges 10/08/2006
20.00 Plums 10/07/2006
I need to build a file to populate a database like
123456 Johns Account 10.00 Apples 10/08/2006
123456 Johns Account 20.00 Grapes 10/07/2006
987654 Bobs Account 10.00 Oranges 10/08/2006
987654 Bobs Account 20.00 Plums 10/08/2006
This your classical hierarchial report, the challenge I have had is in
exeucting the append, defining the header and detail records. Please
help, this has been eluding me for some time.
123456 Johns Account
10.00 Apples 10/08/2006
20.00 Grapes 10/07/2006
987654 Bobs Account
10.00 Oranges 10/08/2006
20.00 Plums 10/07/2006
I need to build a file to populate a database like
123456 Johns Account 10.00 Apples 10/08/2006
123456 Johns Account 20.00 Grapes 10/07/2006
987654 Bobs Account 10.00 Oranges 10/08/2006
987654 Bobs Account 20.00 Plums 10/08/2006
This your classical hierarchial report, the challenge I have had is in
exeucting the append, defining the header and detail records. Please
help, this has been eluding me for some time.