Removing items from a RadioButtonList
-
We have an application that uses a Radiobuttonlist of 36 items for the user to identify a Reason for a visit. This application has been in use for over 3 years and has created over 40,000 records in a MS-SQL Table. The users of this application would like to recude the number of Reasons in the Radiobuttonlist down to 11. Besides online access, they are able to generate various stat reports using this data. How can I do this and still bring up records that contain Reasons that are no longer on the Radiobuttonlist without generating an SQL exception? I don't think it can easily be done. If I could hide the no longer in use reasons, I could use code behind to show these reasons in a separate field on the screen rather than in the Radiobuttonlist as a selected item. Same thing for the reports. I hope this makes sense. Any advise will be much appreciated. :confused:
-
We have an application that uses a Radiobuttonlist of 36 items for the user to identify a Reason for a visit. This application has been in use for over 3 years and has created over 40,000 records in a MS-SQL Table. The users of this application would like to recude the number of Reasons in the Radiobuttonlist down to 11. Besides online access, they are able to generate various stat reports using this data. How can I do this and still bring up records that contain Reasons that are no longer on the Radiobuttonlist without generating an SQL exception? I don't think it can easily be done. If I could hide the no longer in use reasons, I could use code behind to show these reasons in a separate field on the screen rather than in the Radiobuttonlist as a selected item. Same thing for the reports. I hope this makes sense. Any advise will be much appreciated. :confused:
Best thing to do is have your user do a mapping from Old reason to new reason, then clean the data and enable the new 11 radio buttons. For example: Old reason = A, New reason=B Old reason = B, New Reason=B Old reason = C, New Reason=X you get the idea. Good luck :thumbsup:
-
Best thing to do is have your user do a mapping from Old reason to new reason, then clean the data and enable the new 11 radio buttons. For example: Old reason = A, New reason=B Old reason = B, New Reason=B Old reason = C, New Reason=X you get the idea. Good luck :thumbsup: