expression to populate a field from 1 table into another table

[newbie11]

Hopefully an easy question.

I have 2 tables - a USERS table and MESSAGES table.  The USERS table contains an email and name of the user.  The MESSAGES table contains a reference column for the USEREMAIL().   I'm trying to figure out how to also pull over the NAME from the users table so that when a user writes a message, the message will indicate who(name) wrote the message.   

To pull in the user's email I created an 'Initial Value' = USEREMAIL().   So I accurately get the email address of the message creator in the MESSAGES table right now.  Just can't figure out how to associate that with the NAME of the author of the message so that the name can be displayed with the message.

[TeeSee1]

https://help.appsheet.com/en/articles/1090811-dereference-expressions

is your answer.

[your user email col in MESSAGES].[name col in USERS]