Access Database Gripes

I have an application where I need to have categories, and each category can have a parent category. However, I can’t do this in Access using one table, as tables cannot have entries that refer to items in themselves. So, I’ll need to have a Category table, and also a Category Parents table, which has the relationships in it. Bah.