>>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.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer