Walter,
I have this situation. We have a Lender table with Code (Char 6) made as PK. This table has already one record with empty code (by design). Now I can't issue APPEND BLANK. What would be your advice in this situation?
Thanks in advance.
>John,
>
>>Ack!
>aww
>
>>Kevin, don't do it! Don't base primary or candidate keys on user data!
>
>Well, I knew some people were against using intelligent primary keys, but I really wonder what's against intelligent candidate keys. Where do you want to use candidate keys. And more important how do you force a userdata value to be unique troughout the table ??
>
>Walter,
If it's not broken, fix it until it is.
My Blog