need an expert solution for a typical problem as below;
In my form, i have a combo and an edit box. Combo has values as "YES" and "NO". If yes is selected then input into editbox is mandatory, and the text entered in the editbox shall be saved to database. Combo box values shall not be stored into database. Hence when the form reopens after saving the data, it shall query database for the values as entered into editbox, the query shall take other input parameters which are out of scope for this question.
If the record is found the editbox shall be populated with the value and combo box text shall be set to YES.
But combo box can take NO and also it can be left blank , hence how to set the text for combo as per user input when the form reloads after saving whether it is no or blank?