InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 11:04:53 GMT20http://www.sqlservercentral.com/Forums/Topic524926-1297-1.aspxHi,I am designing survey database and for one entity I need to store dynamic field's Name and his data this data will change for each survey.So, For this I have created one table with 8 fields of different datatype 3 varchar, 3 Int and 2 DataTime.Now, user can use these fields to upload the data. Before upload they will define the field names for the specific survey, And ensure that data type of the value should matches with the field data type.Ex: For survey 1 if user want to upload Age, Networth and profession data then user will select 2 Int and 1 varchar field and define the fields as Age, Net worth and ProfessionCurrent table design is as follows:Field_Name_master:Id IntFk_Survey_Id IntField1 VarcharField2 VarcharField3 VarcharField4 IntField5 IntField6 IntField7 DateTimeField8 DateTimeFields_Data Table:FK_Field_Name_Master IntField1 VarcharField2 VarcharField3 VarcharField4 IntField5 IntField6 IntField7 DateTimeField8 DateTimeCan any one suggest the best practice for this type of table design?Fri, 27 Jun 2008 06:40:45 GMTJoyKing