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