|
Thank you for everyone's help.
I took out the category field in the animal table. Created a link table category_animal(category id, animal id). And when adding a new animal it asks the user for its lowest category, (eg python and not just snakes), and it adds it in pythons, then looks at pythons parent and adds it there, and so on until it gets to a top level category!
|