I think you could make your idea work. I also think you could take it a step further and do some stored procs to generate materialized views with the data pivoted for each of your units. So, you'd have your unit table joined with the attributes table of which you spoke, such that you could dynamically maintain a list of which unit uses which attributes, and then get the corresponding data and generate a pivoted view, if those were needed.
-d On 4/19/07, Jim Davis wrote: > ID Source Attribute Value > ---------------------------------------------- > 1 A FName Jim > 1 A LName Davis > 1 A PolicyNumber 11111111 > 2 B PolicyNumber 222222222 > 2 B AccountCode 231234-d > 2 B SSN 123456789 > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275854 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
