Get Hierarchy for a record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I am having a table in MS-Access called CATEGORY_MASTER. The structure is:
CATEGORY_CODE
CATEGORY_NAME
CATEGORY_PARENT

We can insert category details, sub category details inside this table.
Master categories are not having the values in CATEGORY_PARENT field. ie.,
having only null value. For the sub categories, they are having their parent
category code in CATEGORY_PARENT field. Now, i want to get the hierarchy for
a category code. I can do this task in Oracle by using "connect by" and
"start with" caluse. Is there any way to do the same task in MS-Access?
Please help me out.

Thanks.
 
Hi,

Not built in. You can transform your table into a nested set and use the
nested sets relations..


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top