|Subject:||Re: Uppercase to Mixed Case Edit in Field|
|Date:||8 Aug 2006|
Wait, you didn't use the vendor's actual name as a primary key, did
you? BAD design. Very bad. I mean, how many Smiths are in the phone
book? That's just asking for trouble. Your first relationship will
work okay, but what happens when you really do have a second "John
Smith". Make the primary key an autonumber, and then base the
relationships on that. If you want to convert the text to propercase,
use something like this:
Of course, if you have exceptions to the "first letter capitalized"
rule, you're SOL.
Uppercase to Mixed Case Edit in Field posted by sara on 8 Aug 2006