>>We have a cutomer table, and a customer_phone table. The customer has an unique 'account' number. I'd heard that it's "unwise" to use such a field as a primary key, that it's best to create another field for it. Is this true, and why?
>
>I suggest looking at articles on this subject in FPA by Mac Rubel. From what I remember, he went into great detail about what to use and why.
>
>Wayne

Actually, Mac went into great detail about why integer is better than character. There is an article on my website that discusses primary keys.