Balaji-129603
Newbie
Points: 9
More actions
April 12, 2004 at 8:42 pm
#161361
I have one table named "ut_Sections" with fields
Section_ID, Name,IsParent(bit),PrentSection_ID
Now i should display the hierarchy like:
ParentSection_1
ChildSection_1
SubschildSection_1
ChildSection_2
ChildSection_3
SubchildSection_2
SubChildSection_3
ParentSection_2
ParentSection_3
ChildSection_4
SubchildSection_4
................etc
i should display like this...how can i design the table and and query...please help me.
Jeff Moden
SSC Guru
Points: 1000539
April 12, 2004 at 10:41 pm
#502489
Lookup "hierarchical information" in Books on Line for an example. Has a bug in it but shouldn't be hard for you to find.
--Jeff Moden
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply