> Isaac - thanks for the information. I'm going to take your pointers and > start doing some data modeling to see if I can make this work. I wonder > if I can denormalize the data into a 4th table as things progress to > keep the madness to a minimum..
Your welcome. :) Somehow the 4th table seems like a good idea ... I still haven't come up with a really decent way to denormalize it -- not sure where I'd put a 4th table... S. Isaac Dealey Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
