Hello all, I'm new to FileMaker. I have a Zip Code/City list that I have imported into FM. I was hoping to format the City field so it automatically fills-in when typing the Zip Code. While I DID accomplish that, my problem is that several cities have the same zip codes, and FM defaults to the city at the top of the alphabet. How can I have all of the cities within the same zip codes to pop-up so I can choose the correct city? Example: I type the zip code in (12345), and JUST the cities with the zip code (12345) popup to choose from.
If there is a simpler solution, I'm happy to try it. Thanks