3rd and 4th level details off existing details

[codecomm]

I have a question which I'm not sure how to tackle.

We had initial specs of a master detail specification, but now they want "grandchildren" and "great-grandchildren".

So, instead of a simple master / detail, it's now a:
master
detail
grandchildren (details of details), 3rd level
great-grandchildren (details of grandchildren), 4th level

Can the details view have details off itself, then another level lower....basically, so I can now show all four levels?

Also, when the user clicks on one of the 10 master records, and goes to the 2nd page for the details, the customer wants the 3rd and 4th levels to show as well...and, I'm not really even sure how to do that.

So, an example flow would be:
I have 10 southern states, which are the masters.
If I click on any of the states, I'm taken to the details page which lists the cities of that state.
Under each of the cities, I show the counties...which would be the 3rd level, grandchildren.
And, under the couties, I'd show the sub-counties...which would be the 4th level, great-grandchildren.

Thanks!

 

[GoTerps88]

This looks like an ideal situation to implement a tree view control. IMHO it's the way to go if you need to display a hierarchy that spans several layers.

You can map a tree view to data within code but requires a bit of work.

As for showing details that gets a little trickier.

 

[codecomm]

I created a test schema with:
1. Parent/main table
2. Child/details table
3. Item/Activities table

I did this because all data coming into the database is in one of three categories:
1. A goal which goes in the parent table
2. A detail which no matter what level goes in the Child/details table
3. An activity associated to a detail

I've populated with test data as to customer's requirements, and have been able to successfully report off the data.

 

[ca8msm]

You could have also used nested Repeater controls. They are quite straight forward to implement, and give you flexibility over the output.


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]