2 Replies Latest reply on Apr 9, 2013 12:30 PM by anthonyb

    How do I code a cell to read as a two letter digit

    anthonyb

      I would like to add a drop down box to display the complete word and the cell read and print as a two digit code for example : Mississippi = MS and then in the address field use zip code to auto fill City? Is this possiable?

        • 1. Re: How do I code a cell to read as a two letter digit
          Mike_Mitchell

          Anthony -

           

          For a requirement like this, it's probably best to have two "domain" tables. In one, you have two fields: StateName and Abbreviation. You'll then create a value list based on the two fields. You'll use Abbreviation as the first field, but sort and display only the second field, StateName. When a user selects "Mississippi", the system will automatically choose "MS" (because that's the actual value of the list) and insert it into the field.

           

          Your second table will be similar, but larger. What you'll do there is have, again, two fields: ZipCode and City. In this case, though, instead of a value list, you'll define a lookup based on a relationship between the ZipCode table and the table where the address is being entered, with ZipCode = ZipCode. Choose to Lookup the value of City from the ZipCode table and insert it into the address.

           

          Let me know if you need further detail. HTH

           

          Mike