>> ...I ended up sending a fairly detailed response which >> explained how to store id's and labels for the properties >> in one table >> and the values for properties in a 3rd so that the >> application would >> have only 3 tables and require no additional schema >> changes rather >> than continually adding columns or tables.
> So you described a 1-to-many bridge table. :) I know > exactly what you > mean. In fact, what you described is what we have to > fight with all the > time, because some of the designers of the databases we > use don't > understand good relational DB practices. Okay, I give, it's hopeless... :P Once you get to a) someone else wrote it and they didn't know better and b) I'm not allowed to change it, then you're screwed. :P s. isaac dealey 434.293.6201 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234620 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
