1.      I will need nine pairs of numeric fields that will be named “Run_1_Total_Hours_Below_Rotary” and “Run_1_Total_Circulating_Hours”, “Run_2_Total_Hours_Below_Rotary” and “Run_2_Total_Circulating_Hours”……..

2.      Every pair of fields will be hidden on form load.

3.      The operator will select a value from each of the drop down menus in Pulser_Reports in order to filter the matches that are stored in Lifetime_Hours. The fields that need to be matched in the filter as follows.

a.      Pulser_Report – Job_Number must match Lifetime_Hours – Job_Number

b.      Pulser_Report – Description must match Lifetime_Hours – Pulser_Size

c.      Pulser_Report – Serial_Number must match Lifetime_Hours – Serial_Number

4.      For each item returned with the three variables from above matched, I need to look at the Lifetime_Hours - Run_Number column. If the value in Lifetime_Hours – Run_Number = 1 then “Run_1_Total_Hours_Below_Rotary” and “Run_1_Total_Circulating_Hours needs to SHOW, If Lifetime_Hours – Run_Number = 2 then “Run_2_Total_Hours_Below_Rotary” and “Run_2_Total_Circulating_Hours needs to SHOW, etcetera.

5.      Each pair of fields that are shown then need to be populated as follows. I will reference “Run_1_Total_Hours_Below_Rotary” and “Run_1_Total_Circulating_Hours” for my example.

a.      Pulser_Reports - Run_1_Total_Hours_Below_Rotary will be auto populated with the value in Lifetime_Hours -  Service_Hours_Below_Rotary

b.      Pulser_Reports - Run_1_Total_Circulating_Hours will be auto populated with Lifetime_Hours – Service_Hours_Drilling

Thank you in advance for your time,

Jason Rapp