AnsweredAssumed Answered


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




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