>You see, right now, as you suggested, the report can be created without multiple detail bands. But I need to enhance the report and to add another table. Therefore, I will truly have a case for multiple-detail band. Here is what I have and will have:
>1.Main table (Work Order) of one record (actually table has many records, but I need to report on one record only, that's why I use NEXT 1 in the Report form command.
>2.Child table: parts. Related to the Work Order table.
>3.Child table: tasks. Related to the Work Order table.
>Right now, in my initial testing, I only have 1. and 2. But it does not work. I suspect that the cause is NEXT 1. I will test an approach without NEXT 1.
>
As I suspected the NEXT 1 is what causes the problem. That is, VFP "executes" this command "NETX 1" not only for the cursor used for detail 1 band but for any other detail band. Therefore, only one record is printed for every cursor and every band. I changed the REPORT FORM not to use NEXT 1 and all seem to work fine.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham