A primary key is a SINGLE field used as the record identifier. It really
should have no meaning to the user and in most cases never seam by users.
In all the databases that have worked with the have multiple fields for a
primary key have made it a lot harder to do anything, even things that should
be simple. I would never create one that way. I probably am glad the there
are people that recommend it (like Blue Claw) or actually do it so that I
will get lots of work fixing the issues it causes.
--
Boyd Trimmell
aka HiTechCoach
http://www.hitechcoach.com
http://www.officeprogramming.com
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200712/1