I'm trying to create lookups, or some other form of it, to easily populate fields, but I'd like to minimize the number of Data Lists I have to create.
This is part of my Rig Type list in my Library Data.
I'd like to put as much info about our drilling rigs in this one list as I can.
On the Borehole Tab, I've got the Rig Type field, where I want the yellow column. Easy.
On the Sample Tab, I've got the Hammer Correction Factor Field. I'd like the HCF number to go in there, either automatically, or as a pull down. I've got HCF currently formatted as a Single and a separate HCF list, but I'd like to get rid of that list.
HCF is a number I use on the drilling log report, and as part of a calculation, so it also has to be accessible in that fashion.
I'm getting the feeling that combining everything into one list is going to create some logistical nightmares and I should just keep everything separated out.
Do I have options here?
Hi Jeff,
I see 2 options.
1. If you want to populate a field with a value in one table based on a value from another table you would need to write gINT rules code see below gINT rules guide. This is meant for programmers who can code in VBA.
2.If you just want to use the correction factor on the reports you can reference the fields from the library data table you created using lookup functions. This would not populate a filed in the sample table , but you could pull them into the expression on the reports.
for example lookup the hammer correction where the Name field in the library table = the rig type field in the point table.
In gINT go to Help..search for the <<Lookup()>> function it wil give you details on usage and examples.
If you have more detailed questions on the lookup function please contact me at kirk.Johnson@Bentley.com