Hmm this sounds like a good approach, something I never done before, I just need to make sure I use the correct MySQL syntax to connect the tables, sometimes I get mixed up with using the wrong joins, such as inner, left joins etc. Once a friend suggested I store a collection of category ids as an array in a record, but to me that sounds like a lot more coding I need to keep making sure is used correctly. I'd like to see how far I get with using your method, are there any other considerations I need to make sure I do correctly? For example how they are used in a drop down menu? I may very well do a support ticket for this to get the menu working correctly. I just want to see how far I can get first before doing that.