>I have a transaction table that holds bank informations. In this table there is a field that holds a bank id number and another field that holds the account number for that bank. I have a lookup table that holds all the account number for all of my banks and each of these account has its own system generated unique id number.
>
>My question is, in the transaction table in the field where I keep track of the account number for a bank, is it better to save the actual account number or the system generated id for the account number.
>
>You thoughts will be greatly appreciated.

I would say system generated id...

Nick