How to have a custom value option other than the pre defined ones in Master data selection

Posted by Shoab.Shah under Sql Server on 7/29/2015 | Points: 10 | Views : 881 | Status : [Member] | Replies : 1
Hi All,

I have requirement wherein user is provided with multiple radio buttons / check boxes from which user will do selection. There is an extra textbox provided labelled as other: [____________] .

I have master table called Qualification from which the Ratio buttons will be populated. Further have Candidate table in which the selected radio button value will go in Qualification column. I don't know how to implement the extra option in master table 'Qualification' and operations table that i.e. 'Candidate'.

Please direct if have posted question in a wrong section.


Posted by: Shoab.Shah on: 7/30/2015 [Member] Starter | Points: 25

One of the inputs i received was

You can add another column to your Candidate table then modify any select statements you have to also check for that value. Alternatively you can add the value of Other to the Qualification table, then add the value to Candidate as normal.

Kindly suggest whether this option is OK or there is better alternative.

Shoab.Shah, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response