AnsweredAssumed Answered

Sorting issue Numbers with Letters

Question asked by kashaev on Nov 29, 2012
Latest reply on Nov 29, 2012 by kashaev


Sorting issue Numbers with Letters


     I have a DB of equipment items on a project.  Each item is assigned a number 100-999...sometimes there are "accessories" to the item and the number becomes 100a...100b...100c.  The field is actually set up as a text field to allow for this.  When printing and viewing on the screen the items are sorted by project number and then item number, no problem.  SO..I have my first project that goes above 999 I have 1000 and up to 1105.  Now when it sorts it mixes the 1000s and 1100s in with the 100s. Example:   The order no goes  100, 1000, 1002, 1003.....1009, 101, 102, 103...1100, 1101, 1102...

     I assume this is becuase FM is seeing this information as text instead of a number.  But if I switch to the field being a number I cant use 100a,  100b.....

     Is it possible to have the best of both worlds here?