Hi Andrew,
Unfortunately currently there would not be a way to get that looked up report to populate based on picking it in the dropdown prior to a save. That is because the relationships and the data flow isn't finalized in the way that it is currently checked. So you can't get a visual like that to show till after the save is committed. If being able to see that ahead of a save is helpful I would suggest putting that in as a User Voice request. User Voice is a tool our product development teams use to track user interest in new features and enhancements to existing features. The Quick Base User voice can most easily be accessed from the My Apps page in Quick Base by clicking on the orange Feedback tab that appears on the right of the page or at
http://quickbase.uservoice.com by signing in with your Quick Base credentials.
If you do make that request I would suggest adding a link to it here in this thread so that other users with the same need can add their votes as well. I hope this information is at least helpful Andrew and thanks for your time today .
------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------