AnsweredAssumed Answered

Lookup value - not sure what to do - any help appreciated!

Question asked by lobstah on Oct 12, 2017
Latest reply on Oct 17, 2017 by jbrown

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?

 

Thank you-

Outcomes