>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
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown