Hi all
I had 3 tables account.dbf,bill.dbf and ledger.dbf
in my prg....

USE account ORDER ac
USE bill ORDER ac IN 0
USE ledger ORDER ac IN 0
SELECT account
SET RELATION TO ac INTO bill,ac INTO ledger
REPORT FORM test
SET SKIP TO bill,ledger
REPORT FORM TEST

account a got 2 records in bill and 4 records in ledger
account b got 2 records in bill and 1 record in ledger
why some record missing in my muti detail band report ?

account a
bill date 02/02/14 amount 456.00
bill date 03/03/14 amount 789.00
bill date / / amount 0.00
bill date / / amount 0.00
ledger 01/01/14 desc xxxxxxxxxxxxxxxxx amount 1.00
ledger 03/01/14 desc yyyyyyyyyyyyyyyyy amount 2.00
***another 2 records missing

account b
bill date 01/01/14 amount 123.00
bill date 02/01/14 amount 444.00
ledger 02/01/14 desc zzzzzzzzzzzzzzz amount 1.00
ledger / / desc amount 0.00
***additional blank record in ledger

please help me !