>Lets's say you had stock transactions to go with your stock code. In the
>transaction table, would you use the stock's PK, or the stock code, as a
>foreign key in the transaction table?

I would use the stock's PK. I would treat the stock code as a changeable, user-supplied value, and not trust it for maintenance of database integrity.

Dan.