> 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?
I would have one table "hobby": Hobby_id, hobby_desc, etc, etc. And another hobby_lookup: Hobby_id, profile_id This would allow each hobby to be attached to many profiles, and each profile to have many hobbies. This would also allow you to easily add new hobbies as they come up. Your lookup table could get very deep (number of rows), but as it is very narrow (in columns) the filesize should not be a problem. HTH, Rich ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288736 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
