I have a profile form that has about 7 drop-down menus (marital status, education level, etc.), all required fields.
How do most handle this? Do you create a separate table for each collection and then have foreign keys on the "profile" table, or do you simply pass in literal values to the database from the select fields? Obviously, with the latter, any changes to the structure of the collections would be difficult and bulky. But with the former, will there be a significant database toll for all of the joins in the sql statement that will be necessary to display literal values of the foreign keys? Is there a better third (or forth) option besides these? Thanks! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288698 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4