Not sure if this is possible but I have a table with operator IDs but I want the IDs to show names instead. I know i can manually go in and add in the translation list but i have a few hundred employees and new hires coming in and out all the time. So if I could automate it to cross reference a table i already have built that would be a god send.
are these in database tables already? If not, I would look at putting them in tables so that you can easily show it how you want.
So the main table has the results from the production line where they scan there badge in. Then i have a table for my badge id to name link.