3 Replies Latest reply on Mar 28, 2012 10:08 AM by philmodjunk

    How to Sort with Multiple Entries in a Field

    LDel

      Title

      How to Sort with Multiple Entries in a Field

      Post

      I would like to sort our tank numbers in ascending order. The fields are already set to Number.  Some of our fields have 2 entries.  Currently, our FileMaker Pro 9 puts all of the fields with multiple entries at the end. Is there a way to fix this? For example:

      Stock    Tank

      1         5

      2         6

      3         7,8

      4         10

       

      (Right now, it would sort it Stock: 1, 2, 4, 3)