Not sure I follow. Put each individual value in a column? ie column1 = keyword, column2 = keyword, columnN = keyword?
Just set an upper bound on how many keywords to allow. A keyword look up table so to speak. userID, colum1-N NOOOOO!!!! That is worse then the list you are currently using. ITEM TABLE ITEMID ITEMNAME ITEMDESCRIPTION KEYWORD TABLE ITEMIDFQ (foreign key identifying a record in the ITEM TABLE) KEYWORD There would then be multiple rows in the KEYWORD table one for each key word assorted to the an item record in the ITEM TABLE. This is a overly simiple example but shows the basic relationship. -------------- Ian Skinner Web Programmer BloodSource www.BloodSource.org Sacramento, CA "C code. C code run. Run code run. Please!" - Cynthia Dunning Confidentiality Notice: This message including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender and delete any copies of this message. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226225 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
