Re: Table Design In General

Chris wrote:
> Ed,
>
> Thanks for the input. I am most definitely in contact with the DBA who
> will be over-seeing the database. He is in favor of the "dumb" key
> concept. here is the reasonig behind our logic.
>
> In this industry (music & entertainment distribution), the
> manufacturers assign a "part number" to their products as a way of
> uniquely identifying them. In our own product table, if we were to use
> that part number as the intelligent key to our product table, we would
> run into a problem because the part numbers actually change (more often
> than you would imagine).

Darn! My Elvis LP just turned into a widget! Part numbers don't change.

-- 
Regards,
Frank van Bortel
Old golfers don't die - they just loose their balls.