I am using ColdFusion 9 and SQL2005. I am trying to come up with a breadcrumb trail I can place at the top of the page. Example... Home > Departments > Building. Each level would be a link to that page of the site. I want this to be database driven and not based off of the structure of the site. In my database I currently have PageID, ParentID, Title, Link. I'm not sure if this is the best way but what I was thinking was that every page would have a record in the database and be identified by PageID and if it had a parent page that field would have the parents PageID. Title and Link would be used for the link in the trail. I attached an image of a small example of the database I currently have. Any help would be greatly appreciated.