Recent content by Plarent

I have an ASP application where the users add fields to the database table as well as to the screen. Basically the users can configure their own screen. So, I have an Admin Page where users can add fields and change the location of the fields and the Page where the data is displayed. I have...

Thanks for your replies. I am doing this for a web application where the users (basically their adminitrator) can add fields on the fly and show them in the application. As far as having separate fields for different data types, I imagined it would be the easiest way to query information. You...

Thanks for showing interest in this and sorry for the confusion. Here is how the tables look like. ID FieldName FieldType 1 LastName1 Char 2 FirstName1 Char 3 BirthDate1 DateTime 4 Age Number The Other Table Looks Like ID FieldID CharValue DateTimeValue...

I have designed two tables. One of them holds, as records, fields for the other table. So, for example, I have Table1 with ID, FieldName and DataTypeID. The records in this table have a unique ID and then a string value like FirstName, LastName, Phone Number etc and Int, char or datetime...