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

    Sort doesn't seem to work



      Sort doesn't seem to work


           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




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

               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.