I don't have exactly what you are looking for, Dan, but I often use an
effective date column to do similar lookups. I can send you an extract
of how it works, if you like.
Albert
On 23/05/2013 11:50 AM, Dan Goldberg wrote:
We are planning on making a change to our bill of materials to add
revision control based on effectivity dates. Currently we do it
manually and is a pain.
Does anyone have a database structure/designs that include revision
control/effectivity dates that they are willing to share/sell?
I have been scouring the web but have not had any luck as of yet.
TIA
Dan Goldberg
No virus found in this message.
Checked by AVG - www.avg.com <http://www.avg.com>
Version: 2013.0.3343 / Virus Database: 3184/6350 - Release Date: 05/23/13
