Re: Natural keys vs Aritficial Keys

"Walter Mitty" <wamitty_at_verizon.net> wrote:

>One nitpick. A GPS device gives you a measure of where something is, not a
>key to its location, unless I misunderstand how GPS works.
>Using measures in place of keys is tricky, even though it looks simple at
>first.

"give the guys a device which had a hand held computer of some sort with a bar code reader and a GPS. "

So you have three pieces of data, bar code number identifying the peice, location and date/time.

Tony

-- 
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/