AnsweredAssumed Answered

Autofill postcode based in city

Question asked by FilipePimentel on Dec 13, 2013
Latest reply on Dec 15, 2013 by philmodjunk

Title

Autofill postcode based in city

Post

     Hi there, 

     I have a solution where I enter de zip code and the city comes up. That is good, but where we live, people know city names better than they know the zipcodes. 

     So I am trying to change so the user enters the city and the post code comes up. No...there is no city with two zipcodes, as the cities are very small (20-90k inhabitants), so there would be no two zips for one city. 

     I tried reversing the lookups but I am not getting anything. I have for the Solution "enter zip and get the city" I have:

     company::Zip >------< Zip::Zip

     then lookupNext: 

     lookupNext (Zip::City; Higher)

     The company::Zip field uses the value list from Zip::Zip. 

     ********

     For the Solution "enter city get Zip"I had to create a new table occurrence of the Zip Table

     MainTAble::ZIP >--------<Zip2::Zip

     And my lookupnexts:

     Zip: lookupnext (Zip2:Zip; Higher)

     and the city using value list Zip2:City

      

     Any help is appreciated

      

     F

      

Outcomes