Re: Natural keys vs Aritficial Keys
Date: Sun, 17 May 2009 21:33:19 GMT
Bob Badour <bbadour_at_pei.sympatico.ca> wrote:
>The fundamental problem Tony had was nobody ever put bin numbers on the
>inventory bins. Solving the problem is as simple as adding a logical
>identifier, any identifier, to largish areas of the inventory field.
Go for it. Try putting bin numbers on a gravel pad a square mile in size. And actually they do have lanes and such.
The problem is that folks unload the trucks in certain places and then somehow screw up entering where it is. Or the wrong piece gets moved and then put back somewhere else. Or other human reasons.
When you're dealing with 5,000 and 10,000 humans assembling a huge jigzaw puzzle called a refinery, upgrade or oil sands plant stuff happens.
-- Tony Toews, Microsoft Access MVP Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ Granite Fleet Manager http://www.granitefleet.com/Received on Sun May 17 2009 - 23:33:19 CEST