Select name from list to show matching photo in 2nd field?
I have a list of places, all of which have a different coat of arms. I want selecting the name of the place from one drop down or pop up menu in one field to automatically load the corresponding coat of arms for that place in a second field. I can't work out how to do it but feel it must be fairly easy with the right code or calculated field or other clever solution. Both the place name and the coat of arms are in the same table, but when selected they will appear in a layout based on a different table.
Can anyone suggest how this might be done? I think I'm missing something simple here...