Self Relationships in MYSQL or MSAccess

[rrrrr]

Can somebody help me with self 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-mail]
--Tim....

[yelvington]

A category has only one parent, but potentially many children?

Easy: Each category has a unique ID, autoincrement, not null. Each category also has a parent ID field, potentially null. If the category is not a root-level category, its the parent ID field should contain the unique ID of its parent. Tada.