Results 1 to 1 of 1

Thread: two tables, double viewing

  1. Apr 9th, 2007, 04:51 PM #1
    brianbaart
    brianbaart is offline

    Thread Starter
    Lively Member
    Join Date
    May 2004
    Location
    right here
    Posts
    87

    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
    Attached Images Attached Images  
    If Not Now Then When

    If Not Here Then Where
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width