Can somebody help me with slef relationships in MY sql or MS Access 2000.
I want to set up a one to many relationship in the same table in which the primary key is .
Example
Means I want one category which has manysub categories and then many categories have many products.
so it would be
Category
|
|
|
Category1
|
|
|
Category2
|
|
|
Category(N)
|
|
|
PRODUCTS
Now i just have two tables category and produucts..
I want to set up a self relationship a one to many relationship between category and many categories and each category may have many products...
Can any one please help me with this ...
Thank You ,
Email me at <!-- e --><a href="mailto:[email protected]">[email protected]</a><!-- e -->
--Tim....
I want to set up a one to many relationship in the same table in which the primary key is .
Example
Means I want one category which has manysub categories and then many categories have many products.
so it would be
Category
|
|
|
Category1
|
|
|
Category2
|
|
|
Category(N)
|
|
|
PRODUCTS
Now i just have two tables category and produucts..
I want to set up a self relationship a one to many relationship between category and many categories and each category may have many products...
Can any one please help me with this ...
Thank You ,
Email me at <!-- e --><a href="mailto:[email protected]">[email protected]</a><!-- e -->
--Tim....