Link to another record automation

Hi!

Is it possible to create a “link to record” that automatically updates when there are the same two fields in both tables (eg.: User Name)
Because it seems if I create the linking that I need to click in the field manually in order to connect the rows with the same user.

Thank you!