Re: Recursive join - blind alley?
From: Mike MacSween <mike.macsween.nospam_at_btinternet.com>
Date: Sat, 3 Jan 2004 12:50:54 -0000
Message-ID: <3ff6baae$0$52886$5a6aecb4_at_news.aaisp.net.uk>
Date: Sat, 3 Jan 2004 12:50:54 -0000
Message-ID: <3ff6baae$0$52886$5a6aecb4_at_news.aaisp.net.uk>
Fletcher
Thanks. I wasn't dismissing your codes out of hand. I appreciate the advice. As a matter of fact right now I'm looking at materialised paths. This http://fungus.teststation.com/~jon/treehandling/TreeHandling.htm in particular looks interesting. But I repeat I've only just come across this. Though your codes look a little bit like materialised paths (and that's a very top of the head comment!).
Yes, I usually work the way you suggest. Come up with a fairly abstract ER/CDM model (or one corner of it). Then quickly knock up some nonsense tables in Access to see if/how well it works. Missing out the weeks of correct relational modelling and such.
Cheers, Mike Received on Sat Jan 03 2004 - 13:50:54 CET