Hepatitis B shots (TwinRix) are one of our most common immunizations. The lot numbers always change for every shot. (Whereas the lot numbers for in house immunizations only change every few months.). My nurse tried to just manually type in the Lot number ... but when she did, the immunization didn't show up. So she did it again. And again. I figured out what was happening. The immunization was being saved (now the patient had 3 shots of Hep B on the same day ..) but it was not displaying. To avoid enduser confusion, the Lot number should be either uneditable or accept on the fly changes more gracefully.
So, once you added the lot numbers, did the immunizations then appear? Sounds like a SQL join problem where the lot number didn't exist ...
Unless you can think of any objections, I will 1. block the "use" button unless you have selected a lot number 2. prevent the lot number from being edited 3. won't allow a vaccination to be added unless the lot number is present.
No, shouldn't be. But then I might change the way lot numbers are shown and only show eg. the latest 10 or so lots.