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?