Product Catalog/Directory w/categories & sub-categories

[Mel_3]

Trying to build a database "directory" or "catalog" that holds products by category or family.

Categories may have sub-categories.
A product may appear in more than one category.

What tables would you create and how would you relate or connect them?

I tried to start with...

tblProducts
idProduct
ProductName

tblCategory
idCategory
CategoryName

tblCatLinking
idParentCat
idChildCat

tblProdLinking
idCategory
idProduct

But it gets confusing on how to link them up...and I'm not sure I have the tables built correct.y.
For instance... the Parent Child connecting table... tblCatLinking has two links back to tblCategory... I'm not sure you can do this...

Maybe some kind soul will help me out and show me how to do this.

Thanks for any help.

[RuralGuy]

I would start by looking at the Templates that come with Access and those on the MS site. It may already be done for you.

[Mel_3]

- Do you have a link to the Access templates on the MS site?

- I've Googled for their "official" Access forum and been unable to find that.

thanks again for any help.

[RuralGuy]

Try here: http://office.microsoft.com/en-us/te...010152732.aspx