and the Artificial Key won.
I don't know what my problem is with artificial keys. I am a HUGE advocate of natural keys. My problem is, I tend to use "natural" keys where one really doesn't exist. For some reason, I am fixated on avoiding duplication. However, I tend forget what is an appropriate duplication and what isn't. Take the following example:
What do I care if someone duplicates a URL? I mean, really...does it matter if the same link is listed twice? It does NOT. Sheesh! I am just killing myself.
So, in the end, had I conducted a little database design I would have never incurred the problem. So the next time you see me blogging about databound controls or database design issues...please remind me to use artificial keys where appropriate. Thanks!