Table of Records is Unable to Sort Correctly

One of my fields is a Short Text for an Item ID number. We made it a Short Text in case a name needed to be tagged on the end but the Item ID always starts with a number regardless, and is sequential for when they are entered. That field is connected to another object labelled "Survey Questions," and while looking at the table of records for Survey Questions, I will sort the Item ID field from the other object in aceneding/decending order but it is never correct. Certain sections/runs are in order but the sheet as a whole is not. Clicking the sort function on the header will not return the largest or smallest ID value at the top. All the ID #s are numbers right now too, even though it is set as a Short Text. How do I get Knack to sort correctly?