Value list from file won't create an entry for every record if field has same value in it
I have a small table of about 30 records that has only two fields, the city and zip code. I use it in a pop-up menu to select a city and also have the zip code field populated automatically. It works fine except that one town has four zip codes, so there are four entries in the table with the same city name but different zip codes, and the Value List will only create one entry for that city. I know this is the problem because have added a number to the end of the city name so they are different and it creates an entry for all four.
Yes, I do have the "include All Values" option selected.
Does anyone know a way to force the Value List to create an entry for every record in the table?
I am using FMPA v13.