i am using vb6 with data environment and data report.
the parent is the table 1 while the child is the table 2..both tables are connected with the PlateID.
whenever i try to print using a data environment it ends up showing the PlateID from table 1 when there is no value of PlateID found on table 2..
attached is the image of the data report and as you can see the Plate Numbers KVT-124, KVT-126 and KVT-125 along with the driver names shouldn't display since there is no record of transactions.
thank you in advance..