When prompted, add information to a blank field in a report from another table.

Trying to automate batch filed creation. Current process is to create the batch file, then pull a report for "awaiting batch export" which has a field resembling "Related batch export" which is then G...