designing database tables to store data

[uglyeyes]

Hi! I need to do below note sure how can i design database as web application performance is a key to this development scenario: 1. organisation adds up available fields (label and input field) that comes from synonym table 2. ability to add extra fields(label and input field) synonym table as i think might have below cols not sure.. SID, SNAME, ORGID, ORGWGID, datatype -------------------------------------- 1, firstname, null, null, string - generic 2, lastname, null, null,string - generic 3, initialname, 1,1,string - orgid 1 specific 4, givenname,1,1,string 5,fname,2,2,string 6,surname,2,2,string 1. change synonym for existing default fields that will appear in the webform 2. add additional fields as per need for individual organisation (orgid=organisationId, orgwgid=organisation workgroup id) please comment if my requirement is not clear. I am confused how should i design table as user might want to add extra form field i.e a label and textbox/checkbox/listbox/combo/moneyfield..all 27 datatypes available in sql. now I dont know how to do this as there will be about 20 organisation that might use this web application. thanks in advance.

[Henry Minute]

I have a cunning plan! Use two (or possibly more) tables, I haven't completely thought this out. :) First table for Generic data. Second table: OrganizationID NameForAdditionalField TypeForAdditionalField Length... etc I hope that you get the idea. One table contains the 'required' fields and the other table(s) allow you to organise the requirements for each client.

Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”