1 Reply Latest reply on Sep 16, 2009 8:17 AM by philmodjunk

    Drop Down List - Replace data in database file

    ssnodgra

      Title

      Drop Down List - Replace data in database file

      Post

      I am using Filemaker Pro 10 Adv.  I would like to know if it is possible to substitue a value in the database file that is different from a drop down list.  Example,the drop down list has named codes in the drop down list, but I want to store only the code number in the database. 

        • 1. Re: Drop Down List - Replace data in database file
          philmodjunk
            

          The simplest approach is to create a table for storing your values. Place your code in one field and the matching name in a second field.

           

          You can then specify your value list to draw its values from the code field in column 1 and display the matching name fields in column 2. When you select a value from the list, just the code will be entered into the field.

           

          If you format your field to be pop-up menu with this value list. You'll see the name displayed, but will be entering/storing the code number into the field.