Unanswered: Populate data in a table with data from another table
I have two tables in one database. "Teachers" contains (amongst other things) a list of 400 unique ID numbers. "URated" contains a list of 50 ID numbers. I use Access 2007.
What I would like to do is have the word "Yes" appear in the field "Rating" in the Teachers table for each ID in "Teachers" that also appears in "URated". So, every time "ID in Teachers" = "ID in URated", I want the word Yes to appear in Rating in Teachers.