ID Number Search & Number Sorting
Currently, I have a DB file where I use request IDs, which I started at the number 1. When I do a find for request ID 1, I get all the request IDs that start with the number, such as 1, 10, 11, etc. where I just want to find request ID 1. Is there a way to do that? As well, is there a way to do an ascending order where it reads: 1, 2, 3, 4, etc. without having all the IDs with 1 in it show up in the order like this: 1, 10, 11, 12, etc? Or do I have to change my ID format not to start at number 1? But if I do that, I think I would have the same problems for the finding and doing the ascending order. Thanks for the help.