Who did Microsoft find to introduce the feature of allowing multiple values in one field in a table? This must have been extremely difficult for the C++ or C# programmer to pull off. I'll bet that there were Relational Database experts who tried to discourage this programmer (or team of programmers) during the production of this questionable "feature".

---

Reply from Richard Rost:

I know. Tell me about it. It's awful. I'll bet the decision was made by a suit who doesn't know databases. "Uhm, we want to make Access easier for the layperson." No dude! It was FINE the way it was! What's really crazy is that the name of the hidden junction table that Access creates to form the relationship is a really odd sequence of numbers and letters. There's a way to get to it with VBA code, but it's not pretty.