[thelist] Database Schema Suggestions

[Ken Moore]

Hi all,

Burhan wrote:


>The problem I'm having is how to structure the database so that I can store 
>the form data ... specifically, any number of fields that the admin might 
>want. It would be moot to limit the form to /x/ amount of fields.

Consider this.

Form_Table has the attributes of the table, the event, owner, and anything 
else that is common to all forms.

Item_table has a field (something like "Main_Form") to tie it to the form. 
The rest of the fields have the item properties such as item name, data, 
datatype, required, etc. The negative is that your code will need to do all 
of the processing, error handling - and probably you will need to convet all 
data to and from string type in the data field to store it. The advantage is 
that you have absoute control and flexibility.

Ken

_________________________________________________________________
Great deals on high-speed Internet access as low as $26.95.  
https://broadband.msn.com (Prices may vary by service area.)