Hi I was wondering if you could help me. I am currently trying to design a database. This database 4 tables, Main_Cat, Sub_Cat,SubSub_Cat and Prod_parent. How ever, not every sub_cat has a subsub_cat. And waas just wondering how I would link this.
Thanks
Ashley
I have attached an image of what I have so far, if any one could help it would be greatly appreciated
Thanksreplace your 3 category tables with 1 hierarchical category table
do a google search for adjacency model
or see The recursive relationship (http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid518422_tax285649,00.html) (registration may be required, but it's free)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment