Dirk,
I'll try to write an article up describing the basic concept next week. I'll
post in on the OACFUG site (http://www.oacfug.org/.) I'd recommend for
anyone looking to do parent/child relationships in a database, to buy the
SQL for Smarties book by Joe Celko. It's not a beginners book by any means,
but has some really great useful tips for organize your data.
-Dan
+--------+---------------------------+
| name | Dan G. Switzer, II |
|company | PengoWorks.com |
| www | http://www.pengoworks.com |
| mailto | [EMAIL PROTECTED] |
+--------+---------------------------+
-----Original Message-----
From: Dirk De Bock [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 19, 2000 9:21 AM
To: [EMAIL PROTECTED]
Subject: Re: Parent/Child query
I think a lot of people could use something like this so do please consider
setting up a web page with explanations and source code or some such.
----- Original Message -----
From: "Dan G. Switzer, II" <[EMAIL PROTECTED]>
> I have a working model of the "nested set tree" in a working Access
> database. Let me know if you want a copy of it. It works a little
different
> then the standard adjacent list (aka, the parent/child relation) but it
> seems to work really will. The concept is based off of something in the
book
> "SQL for Smarties"-which is a great book.
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
