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.
OK, good. That seems like a good solution. Text field with leading zeroes. Thanks.
As is always the case, there are multiple approaches to problems.
One is to apply a band-aid to the symptom and move on, hoping other, similar, problems don't pop up.
The other is to identify the root of the problem and correct that, so the symptom goes away.
Choose wisely.
One is to apply a band-aid to the symptom and move on, hoping other, similar, problems don't pop up.
The other is to identify the root of the problem and correct that, so the symptom goes away.
Choose wisely.
