Hi,

I am looking for a software that can generate a tree of data. For
example, I am trying to track real estate relationships like a lessor,
tenant, general contractor, and subcontractors. I would like a visual
representation of this relationship based on the values in my database
showing the hierarchy much like a site map or family tree.

Can anyone recommend how I could do this or suggest a software?

Thank you,

Ray

bcap wrote on 03 apr 2008 in microsoft.public.inetserver.asp.general:

> I am looking for a software that can generate a tree of data. For
> example, I am trying to track real estate relationships like a lessor,
> tenant, general contractor, and subcontractors. I would like a visual
> representation of this relationship based on the values in my database
> showing the hierarchy much like a site map or family tree.
>
> Can anyone recommend how I could do this or suggest a software?
>

When you have a database with records, having n pointers to other such
records in it's fields, it really is a just a simple reentrant subroutine,
[except for the graphical part].

ASP-vbscript pseudocode:

depth = -1

function getTheRecord(x)
increment depth
show the content of this record, using the depth for graphic position
getTheRecord(pointer-1)
getTheRecord(pointer-2)
.....
getTheRecord(pointer-n)
decrement depth
end function

getTheRecord starting-record-pointer-here


--
Evertjan.
The Netherlands.
(Please change the x'es to dots in my emailaddress)