Silly Constant Question

Hello all,

In my database, I have a number of numeric codes. When a specific code is encountered, I want to translate that to string. The string, I want to be hard coded as a constant, preferably.

For some reason, I have a brain block that I cannot get around!
Can anyone think of a way to do this without using a bunch of “If’”??? There are a LOT of codes!

Thanks all,
Tim

Create a tab-delimited file of codestring. Drag it into your project so it becomes a string constant. At start-up, split the string into lines and then split each line on the tab and stuff it into a dictionary with the number as key and the string as value.

Use a dictionary - cool Tim! Will give that a try.
Thank you for your response!
Tim