This the 3rd in a series of posts I have made regarding this data entry form which I'm hoping to distribute soon. The purpose is for medical professionals to enter diagnosis codes for a particular patient. The same patient cannot be given the same diagnosis twice. When this happens I get one of those long, confusing ODBC error messages. Example below.
Since this is not a coding error, I don't know how to trap it and translate it into English for the end user. Surely there's a way to code for this. Rather than groping about and jury-rigging this, I'll await your expert replies.