Joel Watson wrote: > 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? > No, you'll have twenty entries in the 'hobbies' table. The middle table - the lookup table - will have up to twenty rows per user - however many hobbies they chose from your form - times however many users.
And with the lookup table just having two key fields in it, you can jam a lot of data into that table without it stumbling. Far far more than up-to-20 * hundreds. :D ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288737 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4