addition of column [message #296777] |
Tue, 29 January 2008 00:58 |
gozuhair
Messages: 206 Registered: January 2008
|
Senior Member |
|
|
Dear All
I have 1 table called sv_warr and it contains 1000 of records and multiple colunm .
I have a radio button on that table column name "claim_type" that contains 2 values "L"and "I".
My user requirement is in case of "I" the system display a list of values and if the user select one value then the system once again display a list of values and again user select the desired value.means 2 input entered into the sytem against "I" value.
In case of "L" no list of value display.
Kindly advice can i insert 2 column in my table or do some thing else.
One more thing 90 % cases are "L" means if i add 2 column in my table then 90 % null value inserted.
Kindly advice can i add 2 column in my table or use separate table for storing that type of data.
Regards
Zuhair
|
|
|
|