Books have a Category and Sub-Category and I'm trying to store this information in a Book Database. How can I best store this information? I could have a related table with an ID number and two additional fields of Category and SubCategory. I could index these two so that the same Cat/ Sub-Cat pair wouldn't occur more than once. However this doesn't take advantage of the fact that most Sub-Categories only apply to a specific Category? Thanks, Andy.