Hi All, I have what seems to be a simple issue, but my experience with database design is limited and its making my brain cramp. I'm looking for some feedback regarding the best way to draw this out: I want to narrow down manufacturers for a product catalog with drop-down menus: menu1 will have 5 available groups. menu2 will show the 5 available divisions in each menu1 group. menu3 will show the 5 available sub-divisions in each menu2 division. ....the selected sub-division will show off the available manufacturers who make applicable products. i interpret the relationships as: the user will be looking for a specific product which can only possibly belong to a single sub-division | 1 sub-division can have many manufacturers who make a similar product 1 subdivision can only belong to a single division | 1 division has many sub-divisions 1 division can only belong to a single group | 1 group has many divisions Can anybody help me out with the table/column organization for this? The reason for doing this is that some manufacturers will make products that fit into several divisions or sub-divisions. Best, Mike
EDIT: This thread can be closed. I've started a new topic in the PHP forums. I basically ran into a problem searching for this in Google which is why I approached DP. For anyone else with a similar situation, I found the information source after searching "Heirarchical Data" along with other obvious keywords.