User defined data collection help ColdFusion

Programming in mysql: User defined data collection help ColdFusion on newest questions tagged mysql – Stack Overflow

I am trying to figure out what is the best way to accomplish data collection.

Here is what I need to get accomplish:

I am building a CRM using ColdFusion & MySQL to collect data.

The data is different base on each user.

User Examples:

User 1: Collecting :: First Name, Last Name, Phone 1, Phone 2, Address
User 2: Collecting :: First Name, Middle Name, Last Name, Phone 1, City, State, Zipcode, Address
User 3: Collecting :: Bank Name, User Accounts, Business Name,  Address of Bank

To summarize What would be the best way to store it in MySQL and allow easy CRUD (Create, Retrieve, Update, Delete). How can i go about letting the user defined their data. Not to mention speed, pulling thousands of record per query by users interaction. Searching the Data etc…

Any example or answer is appreciated.

source: http://stackoverflow.com/questions/11531155/user-defined-data-collection-help-coldfusion
Programming in mysql: programming-in-mysql