Replacing Hard Code w/Reference File Link

[swc123]

I am trying to replace a number of formulas using hardcoded logic.
Grouped on FLD,
If FLD = "joe" then "Joe Adams"
elseif FLD = "pete" then "Pete Rose"
else "Unassigned".

I would like to use a reference table and then print the Full Name from that table. I'm ok for those in the Table, but am not sure how to process those names which are not in the table.
Steve

 

[synapsevampire]

I responded to your other post.

http://www.informeddatadecisions.com

kai@informeddatadecisions.com