I have an Internet CRM product that holds my client database in SQL Server 2008. My clients would like to be able to customize their own criteria with a variety of field types - freeform text fields, dropdown listboxes to select one, lists to select as many as necessary. They ultimately want to be able to create a client registration page that has their own personalized marketing fields and info. Makes sense, but I'm overthinking the process.
I am trying to figure out the easiest way to configure this so they can build their own fields (type/length/selections/etc.) and store their client's data for the easiest way to query/sort in the future. Do I create a single record for every single criteria that a client would select - then delete if they update and no longer want that criteria?
All suggestions are welcome!