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!