AnsweredAssumed Answered

How to Sort with Multiple Entries in a Field

Question asked by LDel on Mar 28, 2012
Latest reply on Mar 28, 2012 by philmodjunk

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)

Outcomes