I've got a handful of categories which I'd like to keep the list of info, for use in logs with older data, but I don't want to keep accumulating new entries in the list. Let's use this example:
we have re-calibrated our hammer on our rig. So after that day, say May 6, for instance, any SPT log will use the new calibration. It's not a problem to put a new calibration in, but I don't want to get rid of the old one, in case we aren't done entering data from prior to May 6.
Here's what our current calibration list looks like:
I've got the Salina CME in there twice now. We still have projects from before the re-cal date. Right now it's not a huge deal, because the list isn't very long. But if we re-cal every year or two, with each rig, soon we will have 20 entries with 4 of 5 for each rig.
We could apply this to several other categories, like Geologist, or Driller, where people come and go. We've got some projects which were shelved in 2015 and are just now finishing them. Employees have come and go, but we still need those names in our logs. I've added drillers from decades ago when we've used historical data.
What's the best approach for maintaining all this info in the database, but yet hide the things we don't need consistently. If I get rid of an option, or even change the spelling, the database barks at me if I go into an old database and start messing with entries.
I hope I'm clear on this. Just not sure how best to handle it.