Thanks, Scott. I'm pretty good at data modeling so I feel like, with enough time, I can solve this problem well. But that's when it occurs to me that this has been solved by many before me who have the benefit of hindsight. Maybe I could save my client some money by either recommending they buy something or I could at least take someone else's schema and start with that instead of from scratch.
BTW, it's not just about normalization. It's also thinking ahead about the requirements for audit trails, historical reporting, knowing what data can be changed and what is never allowed to change once recorded, etc. db ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341991 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
