In my main table resides a list of codes. There is a second table that lists descriptions for these codes. I have a form that searches for records, and then populates a grid by setting it's controlsource to a temporary cursor built by the search. I want the grid to display the description for these codes instead of the codes themselves. I have a function that looks up the code and returns the description, but don't know where to put it so that the grid displays the correct string.
Ideas are appreciated!
Thanks!
Jason Nance