|
Home > Archive > MS SQL Server > October 2006 > table design
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| thomson 2006-10-24, 6:32 pm |
| Hi All,
I have a requirement in which some of the text fields are
customizable by the super admin for eg: Dropdown options, Chek box
options, Can any one tell me how best we can do the table design
Thanks in Advance
Thomson
| |
| John Bell 2006-10-24, 6:33 pm |
| Hi
It sounds like you are customizing the user interface, in which case it
sounds like you need to query a configuration table for the items available.
As far as drop downs if the values are fixed then a flag saying whether it is
available or not would be one solution, although if they are manually entered
or changable a table of configured values would probably be the better
option. You can either keep the shipped values in a configuration (XML) file
or possibly their own set of tables if you expect this to be changed
frequently.
John
"thomson" wrote:
> Hi All,
> I have a requirement in which some of the text fields are
> customizable by the super admin for eg: Dropdown options, Chek box
> options, Can any one tell me how best we can do the table design
>
> Thanks in Advance
>
> Thomson
>
>
|
|
|
|
|