AnsweredAssumed Answered

Counting

Question asked by Jon1009 on Jun 1, 2010
Latest reply on Jun 1, 2010 by Jon1009

Title

Counting

Post

Hello I have 3 tables

 

The first table has the samples which then creates related records in the second table

 

but I can have up to 3 related records in the second table so the ID from table one and appear up to 3 times. Once the sample is approved it creates related records for each test in table 3.

 

what I want to do is count the related records in table 2 and then count the related records in table 3 to see if there equal which will mean the sample is approved ready for reporting

 

Iam looking to do this in a if statment in a script

 

Many thanks

 

Jon

 

 

Outcomes