I have two tables. Both tables (table 1 and table 2) have a field called mrn. What I'd like to do is populate the name field in table 2 with the name field in table 1 when mrn matches.
So for example, if I have mrn 521 in table 2, I'd like it to lookup in table 1 for where mrn 521 exists, and copy information from the name field in table 1 to the name field in table 2.
I have a relationship created between table 1 and 2 with mrn, but I'd completely lost on how to make this lookup work.
Perhaps I'm completely approaching this all wrong?