This has always bothered me with web forms.
Back in 1992, I developed networked databases applications for macOS using Panorama. It included looking up city and state from ZIP codes. The only times I recall it getting the wrong info was in cases of recent city boundary changes.
Panorama still exists, it was so much better than Access or FileMaker.