Data not being populated from related table

[rm2011]

I have 2 tables, 1 that stores reports and another that lists shows to relate to that report. I have a drop down list in the reports layout that is populated from a value list created from the "showid" in the shows table. After selecting a show from the drop down list, the text in the area of the drop-down is populated by only the showID (I must have both, as there may be more than one show with the same name. I have a field right next to the drop down that should lookup the show name associated with the id # chosen from the drop down. It is not being populated by anything for some reason. I have attached 2 screenshots that can hopefully help.

Thanks!

[comment]

I have a field right next to the drop down that should lookup the show name associated with the id # chosen from the drop down.

Actually, your screenshot shows you have the ShowName field from the related table on the layout - that's not a lookup. Still, it should work the way you describe, so you could have a problem with the actual data. Can you reproduce the problem in a new file? If so, please post it here.