Re: Natural keys vs Aritficial Keys

From: Tony Toews [MVP] <>
Date: Sun, 17 May 2009 21:33:19 GMT
Message-ID: <>

Bob Badour <> 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 -
Tony's Microsoft Access Blog -
Granite Fleet Manager
Received on Sun May 17 2009 - 23:33:19 CEST

Original text of this message