>>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.
Funny that we found the exact same issue yesterday. I completely forgot about that message of yours, though, and figured this one by myself.
If it's not broken, fix it until it is.
My Blog