I have a form which contains two fields. The 1st one is a textbox which the user uses to enter a zip code. For example, they may enter 61107-1123.
The 2nd field is a text box also. I want it to populate when the afterupdate event fires from the first field.
But the way it has to work is the 1st field has to do a lookup to a table of UPS zones (see attached file)
So if the user did enter 61107-1123, the lookup uses the first three characters or "611" to enter "005" into the 2nd field. If you refer to the file I attached you will see how this works. We want it to always default to the ground "number".
Note: all of the fields in the UPS Zones table are text now. I assume they should be.