Question about grouping, catagorization, etc...

From: Anthony M. Saffer (anthony_at_NOSPAM.opensource-strategies.com)
Date: 07/30/04 

Date: Thu, 29 Jul 2004 22:07:04 -0700

Hello Everyone,

I'm stuck on a problem that I'm sure isn't that hard to solve. In fact, I've
read the solution a few months ago but can't seem to find it again now (when
I really need it). I am hoping someone can clue me in. Here's the problem:

Let's say I have a table called 'tblCategories' which contains 5 records and
is structured like this

tblCategories
    ID CATEGORY_NAME SUB_CATEGORY_OF
    1 Automobiles
    2 Planes
    3 Buick 1
    4 Cessna 2
    5 Trains

Now, as you can see the "Buick" category is both a "upper level" category
(which means it might have sub categories as well) and a sub category of
category 1 (Automobiles). You will also notice that category 4 (Cessna) is
the same.

My problem is that I need to order these into
category/subcategory/sub-sub-category links similar to the way Yahoo does
their directory. So, on the output page, the output might look like this:

Automobiles
    Buick
Planes
    Cessna
Trains

Basically, I want the user to be able to "drill down" through categories.
Can anyone clue me in on how to accomplish this?

Thanks!
Anthony

Relevant Pages

  • Re: Question about grouping, catagorization, etc...
    ... > 1 Automobiles ... > 2 Planes ... > 5 Trains ... > (which means it might have sub categories as well) and a sub category of ...
    (alt.php)
  • Re: OpenForm
    ... thinking only in terms of Form A. Any clue how to test whether there are any ... > Doug Steele, Microsoft Access MVP ... >> Dim category As String, ... >> Exit Sub ...
    (microsoft.public.access.modulesdaovba)
  • Re: Dim scope within an IF
    ... A Clue By Four. ... > Dim frm As BaseClassFormName ... >> third form that needs to instantiate one of those two forms, ... >> End Sub ...
    (microsoft.public.dotnet.languages.vb)
  • previous record from new record
    ... I really do not have a clue why I get an error in the following situation. ... I have this code associated to a cmd button on a form, ... Private Sub cmdUndoNew_Click ... to the previuos record, the last of the recordset, canceling the new record ...
    (microsoft.public.access.formscoding)
  • Re: previous record from new record
    ... >I really do not have a clue why I get an error in the following situation. ... >I have this code associated to a cmd button on a form, ... > Exit Sub ... >to the previuos record, the last of the recordset, canceling the new record ...
    (microsoft.public.access.formscoding)