Your misunderstanding - I would not really approve of comma separated lists in columns -, I totally approve of bridge tables.
-----Original Message----- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: 07 December 2005 16:04 To: CF-Talk Subject: RE: SQL Question. Compare one list to another As a follow up, Neil... You said: > > I would not > > code or approve it in a DB design Is what you said you would not code or approve the Property, PropertyType, and Property+PropertyType schema? Or am I misunderstanding... Rick > -----Original Message----- > From: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED] > Sent: Wednesday, December 07, 2005 10:01 AM > To: CF-Talk > Subject: RE: SQL Question. Compare one list to another > > > PropertType table > Property table > Property + Type Lookup Table > > > > > > > -----Original Message----- > From: Rick Faircloth [mailto:[EMAIL PROTECTED] > Sent: 07 December 2005 15:07 > To: CF-Talk > Subject: RE: SQL Question. Compare one list to another > > Ok...so...for my own edification... > > If "bridge" table or whatever the true db term is for them are > frowned upon (and on this list I've had people recommend them > for many to many relationships), what is the "best practice" to > solve an issue where, say, there is a real estate property that > is many "property types", such as "golf house" "beach house" > "vacation home", etc. > > What would be the "best practice" in constructing the db schema? > > Looking for clarification... > > Rick > > > > > -----Original Message----- > > From: Robertson-Ravo, Neil (RX) > > [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, December 07, 2005 8:27 AM > > To: CF-Talk > > Subject: RE: SQL Question. Compare one list to another > > > > > > I agree with Russ here, I don't like it (for the third time) and > > I would not > > code or approve it in a DB design but I do not see it being bad > > design when > > the need can or does arise. > > > > N > > > > Each to their own I suppose... > > > > ;-) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226528 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
