>
>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?
>
>
>Regards
>
>Maya

I have, in fact, several such cases. Very often, the user would like to see
a stock code (or an account code) that means something to them. I couldn't
care less about what it means to the user. :-) So I would have a PK defined
as integer in the stock table, that is not visible to the user, and that
would be the FK. Definitely not the stock code, ESPECIALLY if the stock
code is defined by the user.

Regards

Tim


[Non-text portions of this message have been removed]