In your value list setup, the first field should list values from the room table just as field 2 lists the name of the room. Make that change and this should work for you.
Good grief, Charlie Brown!!!!
Phil, Thanks so much for your insight and all you do. Someday I would like to meet you.