2 Replies Latest reply on Apr 5, 2012 5:01 PM by philmodjunk

    Another city/state/zip post...

      Title

      Another city/state/zip post...

      Post

      OK... I'm looking for 1 of 2 solutuions...

      1. Is there finally a way to easily set up a city / state lookup from a zip code... and have it remain current by a web lookup?

      OR

      2. If my text field drop-down list has (for example) "Arizona:AZ"... How can I get the field to only show AZ immediately after Arizona:AZ is selected?

       

      Thanks.

        • 1. Re: Another city/state/zip post...
          philmodjunk

          1) not that's easy, as far as I know...

          2) Assuming you have a table with one record for each state, do it this way: Define a relationship linking your layout's table to the states table by the state name field. Then, put the state abbreviation field from the state names table on top of your drop down list. Give it an opaque fill color and use field behavior on the inspector's data tab to deny access to this field when in browse mode.

          Now, when you click on this field, the drop down list behind it deploys. When you select a state, the drop down list disappears back behind the field and the abbreviation field from the related state names table shows the abbreviation for the selected state.

          • 2. Re: Another city/state/zip post...
            philmodjunk

            1) revisiting that 1. I just downloaded my copy of version 12 an hour or so ago. I may change my answer after further research as I seem to recall a new feature in 12 that may be able to download data from a web site automatically--which would might be a way to update your zipcode table.