I understand how to actually do it in the database. But what if I wanted to know if there is a proper way to do it when I let specific roles in my site create fields of their own. For example: (I am building a conference software.) John is using my site to create an event to attend. He has the usual fields already: username, password, first name last name, email... But he want to add more fields. For example "school affiliation". How would you best handle this situation? I was thinking of creating many to many table... Users that log into my system can attend more than one conference/event so we have the basics like shown above. Then people can attend various events and fill in more data. So:
T:field conference_id field_name field_type field_required T:user_conference_field conference_id user_id field_id data And then I would have to create customer forms for these as they are certainly not conventional. That second table here is like a 3 way cosmic convergence of craziness and I wonder if there is a better way. --- Best Regards, Jason Brower