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

I had a slightly different approach. I currently have a Table that auto populates with the most recent batch info, based on batch type, and updates when ever a new batch record is created.

I'm having a little bit of trouble setting up the import itself, I have the records table importing on itself, but for some reason Batch Info field isn't on the list as a source field.