That's about right... I have nother table in my survey system for options in the select box. this way the question could have an unlimited amount of options in the select box.
SurveyForm SurveyField SurveySelectOptions SurveyFormAnswer I also added another column in the SurveyField table that allows you to set the type of data that question is looking for. Weather its' phone no. zip code text etc... this allows for additional validation before the end user submits the form. -- Casey Dougall Web Applications Developer Ph: 518 743-9424 Fax: 743-0337 [EMAIL PROTECTED] Mannix Marketing Inc. 10 East Washington St. Suite 1, Glens Falls, New York Marketing to New York State Destinations? We offer quality Travel Industry Directories, Including www.Albany.com, www.LakeGeorge.com & www.Saratoga.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234208 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
