two tables, double viewing

Hello All,

I'm using CRXI and VB6.6

I have three tables,

sSQL = "SELECT * FROM (TbSubAfdrukken INNER JOIN TbHfdAfdrukken ON TbSubAfdrukken.Sub_Productieorder = TbHfdAfdrukken.Hfd_Productieorder) INNER JOIN TbToelichting ON TbHfdAfdrukken.Hfd_Artikel = TbToelichting.HfdCdArtikel"
The first and third table both contain one record.
But the second table contains more records
I have made a screenshot of the problem:
If the second table contains 4 records the details section of the .rpt file shows 16 lines.
I must be doing something wrong.
If I view the .rpt file in the Crystal report program it shows 4 lines as expected but when I show the .rpt file in my app I get 16 lines.....
I have searched this forum but I don't know what to look for.

Thanks,
Brian