From the historical use of data mining with respect to the claims handling system and the need to deal with diagnostic / procedural codes, you can switch to a combination of controls. Firstly, I would have a grid (allows more than 1 or 2 diagnoses, so you are not stuck there and must redesign the form, if ever more needed) of the entered diagnostic codes. Above it (or below) there is a text box.
If users have documentation from which they come, and they have codes right there, let them enter the text box freely. When checking the text field, request a table of valid codes and get a code and description to fill in your grid above if only 1 entry is found. If more than 1, display a pop-up window with a grid of options that match your query and allow them to choose from this. Any such selection will be added to your main grid screen. If NO entries are found, it can be from type-o or code that simply does not exist. Then I would drop the line until you ask and the DID will get some result. Then, as previously indicated, call the secondary form to select from the available diagnostic codes. Example: if the Diag code โ12345โ is not found, find โ1234โ, โ123โ, โ12โ, โ1โ until SOMETHING returns with the result.
In addition, for a query, if the text is defined as numeric, a code-based query. If the alpha query is in the description ... In any case, the result set may be displayed from what was found instead of stumbling upon a list of inapplicable elements.
DRapp source share