Thanks Kevan. I'd heard of Joe Celko and his work on nested sets, but hadn't read that article.
Pete -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 28 June 2002 17:07 To: CF-Talk Subject: RE: CF, Flash and dynamic multi-parent zoomable tree ? Just in case you havn't heard of this you should look at nested sets for building the hierarchies; http://www.intelligententerprise.com/001020/celko.shtml -----Original Message----- From: Peter Lutwyche [mailto:[EMAIL PROTECTED]] Sent: 26 June 2002 16:01 To: CF-Talk Subject: CF, Flash and dynamic multi-parent zoomable tree ? I am considering a combination of CF and Flash to visually model a tree-like data structure, to display the complex relationships between various companies and individuals. For example: Company X is a subsidiary of Company Y Bob is a director of Company X Bob is also a director of Company Z Company Z has a subsidiary called Company ABC, etc, etc. I'd like to be able to display where Bob (and everything else) fits into the structure, in an easily navigable form. The idea I have is to do this in Flash, with different shaped or coloured nodes to denote different entity types (eg person, company, partnership). The tree is not single parent/child like a Windows Explorer style tree - each child can have two (or more) parents. There is also a requirement to be able to expand/contract subtrees and to zoom in/out of the structure if it is large (there is no limit to the level of nesting). Oh yeah, and the users want to be able to print the structure, or parts thereof... :-) Anyway, before I finally ask for the earth, I'll get to the point. Could somebody please point me in the direction of any appropriate resources, or share any tips on how they have handled a similar situation in the past. We have sufficient database and CF skills, but not Flash. It may even be a case that a combination of XML and SVG is the best solution, but again we need to skill up there. Regards Pete Lutwyche Website: http://www.mourant.com The information in this email is confidential. The contents may not be disclosed or used by anyone other than the addressee. If you are not the intended recipient, please notify us immediately at the above e-mail address or telephone +44 (0)1534 609 000 We cannot accept any responsibility for the accuracy or completeness of this message as it has been transmitted over a public network. If you suspect that the message may have been intercepted or amended, please call the sender. ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists