Pop-up menu export

[Ted Zingrebe]

Ok probably like a lot of folks that post here, I'm a beginner...

I am having some issues exporting to xlsx files in relation to my value lists.  Basically, I have foreign keys going in to text-fields, using the pop up menu for translation.  However, when I go to run exports, the pop-up menus don't override the foreign keys.  At this point I'm sort of at a loss, as I've come up with very little on the Google machine, in regards to this type of situation. I've tried every way I can think of to change my relationship set ups, but the dynamic nature of the value list is the only option that seems to fit my scenario.

Is there some type of script, calculation field or text w/calculation that I could run that would take care of this? The folks at my work live and breathe Excel, so this is sort of  a project requirement.

Any help is appreciated.

Thanks,

Ted

[comment]

Instead of exporting the local foreign key field, export the Name field from the related table.