What's the best way to list multiple categories in a record/table? To give you an idea, I'll use a animals as an example.
If I use a field called "type", I could put in "pet" for a "dog" record. But it can also be categorized as "mammal". So, to deal with this, I would create another joining table with the fields "ID" and "Category" and add all the records for that one ID.
Ex:
ANIMALS TABLE
ID NAME
001 Dog
002 Monkey
CATEGORIES TABLE
ID CATEGORY
001 Domestic
001 Mammal
001 Carnivore
002 Mammal
002 Herbivore
However, if I'm dealing with thousands of records and categories, what then? And what if I wanted to make use of a tree structure? Is there a better way than this?