Forum Discussion
Key Field Question
I'm trying to create a database with a key field containing 1a, 1b, 2a, 2b, 2c, etc. If I make this a text field it does not sort properly. Is there a way to do this? Thanks for your help.
George, thanks for replying. I have a set of baseball cards that are numbered 1 thru 24. Some of them have variations. The variations of the first card should be numbered 1a, 1b, 1c, etc. If this is a text field, they sort 1, 11, 2, 20, etc. I could do 1.1, 1.2 as a numeric field but I really don't want to do it that way. I hope I'm explaining this so you can understand.
