Somehow I knew I would have to use both. Thanks.
>John,
>
>I agree with Craig. And while using surrogate keys has saved me many headaches, most users hate them. They'd much rather think of their account as PACBELL than 39765. So don't show them the Primary Key, only their own lookup code. It's well worth the little bit of extra effort to keep your users from thinking #@%$^ programmer every time they look at the form.
>
>David.
It's "my" world. You're just living in it.