I am using the solution from 8287
I added a combo box for the city so if someone enteres the city it will populate the zip code.
A couple of issues.... some cities have more than one zip code so
1. if the user enters a city and a zip has been previously entered zip (i.e. existing customer moved to a new city) for a multi zip code city. I need to look through the entire table for more than one zip code and confirm it matches at least one city to the zip code or inform the user
2. if the user enteres a city that has more than one zip do not populate the zip code field but that that the system is not able due to multipul zip codes for that city.
Is this possible?