Making a dynamic crumbtrail?

[toString]

To make things simple, say I have a table with:

PageID
ParentID
Title
Content


I can get the navigation to work, as I only show records based on the ParentID == the querystring. Easy stuff.

But how do you go about making a crumbtrail?

Home > p1 > pg1-sub > pg1-sub-sub > currentpage

There must be something more complex to this. I'm pretty stumped.
I'm using ASP.NET if that makes any difference...

 

[toString]

Cheers Mr B. I did breifly consider working my way through the parentid's like that. It just doesn't seems very 'efficient'. I guess it'd only ever be a max of 5 queries - hardly the end of the world..

I'll give it a go and see what happens... cheers!

 

[toString]

Yeah I guess so. There's even a ready-made crumbtrail in VS which uses a XML sitemap. Could be a solution further down the line - but I'd obviously have to do quite a bit of work at the insert phase.
Especially as I don't have a clue how to make the xml file