No scripting is needed. But you do need the correct relationship to get this to work.
This thread maps out two methods for doing this. I think the "dynamic" link approach will be the best option for you here: Auto Fill
Feel free to post back here with questions if you still can't get it working.
Simple... For those who've done this before.
Many thanks PhilModJunk! I appreciate it.