I have a hospital patient database that keeps each Medical Record Number unique -no duplicates (MRNum). I absolutely must block duplicate patient entries. To add a patient users click a button which opens the Form in add-mode. First field is Name, the second is MRNum. On-exit, if the 'Duplicates' error comes up, I trap it and put up my own message, and I won't let them leave that field until it is fixed. Then, because the Name has already been filled out, they cannot just erase the MRNum and leave it blank (because by filling in Name, the record already 'exists' and must have its unique MRNum for the Jet engine to be satisied), they must change it to something not already used, like 999 or something, then DELETE the entire new record.
Any ideas on how to make this not so cumbersome? Would making MRNum the first field eliminate the problem? Any ideas or recommendations on making this much slicker would be welcomed.
Any ideas on how to make this not so cumbersome? Would making MRNum the first field eliminate the problem? Any ideas or recommendations on making this much slicker would be welcomed.
