Lookup + first date filter

[OscarNava69]

Hi team.

I have two tables like the next:
Table Transfer

ID	Transfer Date
1	03/20/2001
1	10/21/2022
2	01/01/2022
2	11/10/2005
3	03/09/2020

Table Master

ID	First Transfer Date
1	¿?
2
3

How create a calculated column in "master table" that get the first date from the table "transfer table"?

Tanks in advance 

[ChrisMendoza · Accepted solution]

@OscarNava69 - you can do as:

[OscarNava69]

Thanks so much @ChrisMendoza ! 😄