6 Replies Latest reply on Sep 30, 2016 8:12 AM by David Moyer

    value list not showing all values

    petewhit

      FMA15.02.220

      I Setup a drop down list in a portal field for the user to select a part number from a value list using values from part number field in the parts table.

      In the value list setup, uses first id field, but setup to only show the part number from the second field.

      Duplicate part numbers (with different serial numbers) are not listed in the value list. All parts records have unique ID used for the relationship.

       

      Same issue in previous version of FMA 15.

       

      I checked the part number table to see if there was any difference in part number field which would upset the value list sorting. All correct.

      I remain baffled.

      Cheers for any comments.

        • 1. Re: value list not showing all values
          David Moyer

          Hi,

          that seems odd, but how would your user know which item to pick if the part numbers are identical?

          • 2. Re: value list not showing all values
            scottworld

            For better or for worse, this is how FileMaker has always worked -- when you show values by the second field, it won't show any duplicate values. Same thing if you show values by the first field... it won't show any duplicate values. So you'll have to design this in a different way for your users.

             

            There are dozens of different ways to approach this, but one very cool user-friendly way to do this is: have them pick the value from a portal instead, which you place within a little popover button on your layout. Then use a script to set the ID.

             

            Or, for a more basic approach, create a concatenated calculation field that combines the part number with the serial number, and have them choose from a value list based on this calculation field instead.

            • 3. Re: value list not showing all values
              petewhit

              I was just puzzled by the missing items in the list, now I have to check other lists.

              Indeed the user should only need to select a unique PN.

              • 4. Re: value list not showing all values
                petewhit

                Thanks scottworld, I am trying different ways with the value list. It's probably more useful to filter out duplicate values especially when there is a lot of them.

                A portal in a popup is probably the way to go, more info can be displayed to help with the selection.

                • 5. Re: value list not showing all values
                  philmodjunk

                  You can also set up a value list based on just the second field. The user picks a value and a relationship based on the second field looks up the first field values into the correct field. A script trigger runs a script at this point that checks for duplicate values in the related table. If any are found, a popover or floating window opens listing the matching records with additional fields shown to assist the user in selecting the correct value from the duplicates.

                  • 6. Re: value list not showing all values
                    David Moyer

                    just in case you don't already have this in your "toolbox", find PartNumber of ! should find all duplicate part numbers.