3 Replies - 831 Views - Last Post: 21 June 2013 - 09:05 PM Rate Topic: -----

#1 chuyben  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 16-June 13

Parent-chile command control code two tables

Posted 16 June 2013 - 07:54 PM

i am trying to accomplish a project where if the PlateID is not found on table 2 or the child command, the parent will not display the PlateID found on table 1..an example would be of great help and i'd really appreciate it.

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..

Attached image(s)

  • Attached Image


Is This A Good Question/Topic? 0
  • +

Replies To: Parent-chile command control code two tables

#2 maj3091  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 303
  • View blog
  • Posts: 1,796
  • Joined: 26-March 09

Re: Parent-chile command control code two tables

Posted 17 June 2013 - 02:20 AM

Greg, if you're experienced in this area then offer some suggestions to the OP and please stop touting for work in the help forums.
Was This Post Helpful? 0
  • +
  • -

#3 JackOfAllTrades  Icon User is offline

  • Saucy!
  • member icon

Reputation: 6092
  • View blog
  • Posts: 23,612
  • Joined: 23-August 08

Re: Parent-chile command control code two tables

Posted 17 June 2013 - 03:20 AM

Yeah, he was Greg in Arizona like I'm William at Buckingham Palace. :rolleyes:/>

Love these Indian body shops pretending like they're US people/companies. What a friggin joke.
Was This Post Helpful? 0
  • +
  • -

#4 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 574
  • View blog
  • Posts: 2,989
  • Joined: 19-May 09

Re: Parent-chile command control code two tables

Posted 21 June 2013 - 09:05 PM

From google maps:

Your search for dreamztech near 1930 S Alma School Rd, Mesa, AZ did not match any locations.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1