1 Reply Latest reply on Nov 11, 2013 6:21 AM by philmodjunk

    Sort doesn't seem to work

    RichNasser

      Title

      Sort doesn't seem to work

      Post

           I have a table (inventory) that has no relationships (yet).  One field, "Product SKU", is entered using a value list from a different table "Products".  All fields in the initial layout inventory sort just fine.  But when I sort using this Product SKU, the order doesn't change.  I sort ascending or descending and the status bar says "sorted" but nothing has changed.

            

           Does this have to do with the value list?  Thanks

            

            

      Screen_Shot_2013-11-10_at_10.28.49_PM.png

        • 1. Re: Sort doesn't seem to work
          philmodjunk

               Note: Product SKU FK is not a field that I'd use as a foreign key in relationships in most situations.

               Open Manage | Database | Fields and check the field type for this field. I suspect that it is defined to be of type number or is a calculation field with "number" as the specified result type.