1 Reply Latest reply on Jan 9, 2014 11:53 AM by philmodjunk

    Drop-Down List Value Duplicates Not Showing

    YukioKina

      Title

      Drop-Down List Value Duplicates Not Showing

      Post

           I have a drop-down list of names which pulls values from a field in another table.  It's set to show values from the First Name field, while also showing values from the Last Name field, and sorts by the first field.  But any duplicate first names don't show up.  So if I have three "John" names in there, only one shows up.

           How do I get it to not omit duplicates?

        • 1. Re: Drop-Down List Value Duplicates Not Showing
          philmodjunk
               

                    How do I get it to not omit duplicates?

               Don't set up your value list like that. Value lists with the use values from a field option, automatically filter out duplicate values from the visible or sorted field.

               But what you describe would only enter a last name into the field. The first name does nothing anyway here.

               Usually, you'd want a unique ID number for field 1 and a field that combines first and last names--best option is usually a text fields with an auto-entered calculation as field 2.