OOFILE Validation Suite - Test 26
Simple test of counting related data
and intersecting related data
as is often used in producing reports or graphs


table:  Patients
24576   Taylor  Ken 5   5   75000   
22122   Dent    Andy    4   4   50000   
21736   DENT    Trissa  3   3   99999   
12288   Smith   John    2   2   20000   



table:  Visits
22276   4   4   4/10/1994   Flu 
21890   3   3   23/11/1994  Flu 
21504   2   2   1/10/1994   Sore Knee   
17408   2   2   14/10/1994  Measles 




Number of 'Dent' Patients  = 2
Number of Visits prior 1-11-1994 = 3
Number of Visits related to selected Patients = 2
Number of Visits related to selected Patients prior 1-11-1994 = 1
Test Completed