gINT rules

Question

Hi, 
 I was looking for a code in gINT rules to obtain data from a table and use it in another table for calculation. 
 i.e To calculate saturation and void ratio in a table named UU, I need to use the SG value from Lab specimen table. I m not sure how to get the SG value in the code. 
 Pls note that the parent table of UU table is not Lab specimen table. 
 TIA 
 NIsha.

Jesse Greenwald · Accepted Answer

Hi Nisha, 
 You will need to create a Recordset and use SQL to obtain data from a non-parent table. 
 You do this with the gINTRules.CurrentProject property. See the gINT Rules Manual (Help>Manuals) for more info. 
 A number of the gINT Rules Samples use this approach. 
 For an example, look at GR005 in the InclinometerInitialize Sub: 
 
 Or GRA015: 
 
 You will need to make sure you have a reference set to the Microsoft DAO 3.6 Object Library (5.0) for the module (Edit>References). See the External Object Reference section in the gINT Rules Manual for more info. 
 Researching DAO a little bit would also be a good idea.