I have finished the expert 4. I am working on a project that requires to have one field to store more than one value. For example a book is classified under more than one category, ie nutrient, health and biology. Then, I also want to set a combo box with all categories to choose a specified category we want it to show all books related to that category.  May I know which class you covered this topics? Thank you.

---

Reply from Richard Rost:

I recommend AGAINST using multi-value fields. They're OK for simple databases, but they are VERY hard to work with when you get into more advanced topics like SQL and recordsets.

The situation you mention requires a MANY TO MANY relationship which I cover in my Relationship Seminar. I'm also going to be covering it in the next Access Expert class (level 7) which will be out this week... so stay tuned.