Re: primary key debate

Behind the scenes. I've seen too many cases where "this will never change", and it does. From: "M.J. Holley" <datashark@fastlane.net> > >There is a debate going around here on primary key. Taking votes here. >Should the primary key be a field that can be updated (an actual usable >form >field) or should it always be behind the scenes? > >For example, social security number is obviously unique id for a patient >record. Would most of you use SSN as the primary key or would you still >have a "behind the scenes" serial value as primary? > >m > > ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com