How to have a custom value option other than the pre defined

Question

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.

Manas Mohapatra · Answer

Hi As per your table structure I am providing below solution: Solution If user want to put input in textbox then you can add one more field in Candidate table CandidateId (int) | QualificationId (int) | QualificationText Varchar(50)...... If you have any doubt please reply here.

shoab shah · Answer

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 · Answer

Hi Manas Thanks for you reply. 1) TextBox will be one for all choices 2) Below are tables details Qualification table QualificationId (int) | QualificationName varchar(100) Candidate table CandidateId (int) | QualificationId (int) | ......

Manas Mohapatra · Answer

Hi Please provide below information: 1. TextBox will be one for all choices or individual textboxes for individual choices? 2. Provide both table structure.