Data model for Custom fields and Custom forms.

10 pts.
Tags:
data model
Dynamic Forms and fields
performance
SQL Server database
Hi, I plan to build a web application which would have dynamic forms with custom fields. he can create one module, web form having some custom fields.So these fields can be created by customer itself through web application. To make this enable i believe I should have some tables to store meta data details of these custom fields and their properties. few other tables to store their values. Expected Output in Application: ------------ Employee: Employee Number    : 12001        Name        : Denny Cherry Designation    : Senior Database Administrator / Architect Age        : 26 Status        : Active ----------- Table to store Field Properties:cust.fields fldno    fldname          datatype    length    field_control    module 1    Employee No    NVARCHAR 20    Text_box    Employee 2    Name    NVARCHAR     50    Text_box    Employee 3    Designation    NVARCHAR 20    PickList    Employee 4    Status    NVARCHAR     20    PickList    Employee ... ... ----------------- Table to store Field Values:cust.FieldValues RowId  FieldId  value  Pr_Index SecIndex 101    1        12001  12001    NULL 101    2   Denny Cherry 12001   NULL 101    5        26     12001    NULL .... .... I could transpose the fields into columns and display one employee record in a single row. But it would take huge time by creating more number of fields and storing their values. I could successfully make user to create custom fields and forms on their own through this method but I guess I may be wrong in terms of data base model/architecture. How would you recommend to store the fields meta data and their values? Thanks in Advance. Ganesh Kumar

Software/Hardware used:
SQL Server 2005, Java Server Pages
ASKED: September 10, 2009  8:11 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following