Scenario 3 tables Profile table -kpProfileID
profile_hobby table -kfProfileID -kfHobbyID Hobby Table -kpHobbyID The Profile table would have as many rows in it as you have customers The profile_hobby table would have: 1 row per hobby selected in each profile The Hobby table would have 20 rows in it. Hope this helps, William -----Original Message---- -From: [EMAIL PROTECTED] -Date: Sep 18, 2007 12:37 -To: "CF-Talk"<cf-talk@houseoffusion.com> -Subj: Re: One more database question - sorry! - ->you can create a middle table between the two that has 1 profile key ->and 1 hobby key per row. Each profile could have multiple hobbies. ->This would keep you away from the 'dreaded' comma dilimited list in a ->table cell. -> ->William -> ->-----Original Message---- ->-From: [EMAIL PROTECTED] ->-Date: Sep 18, 2007 12:19 ->-To: "CF-Talk"<cf-talk@houseoffusion.com> ->-Subj: One more database question - sorry! ->- ->-Actually, I have one more database question. I have a section on my ->profile-collection form that is a series of radio buttons for ->hobbies/interests. What would be the best way to manage/store these ->values? ->- ->-My initial thought was to create a table with a row for every ->hobby/interest item. Then, on the profile table, I was thinking of ->having a column that would collect a list of comma delimited values ->from the form, from 1 to the number of the hobby/interest items. The ->list would basically match up, sequentially, to the key values of the ->hobby/interest table. ->- ->-Is there a better way to go about this? ->- ->-Thanks to everyone for input! ->- ->-Joel ->- ->- - -So let's say that my form has 20 hobbies/interests. I would be creating 20 entries in this middle table, correct? Is this going to create a problem if I have hundreds of users? - - ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288735 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
