Call a column value from another table based on refference key column

[Rene_Casana_Ama]

I’m trying to call a value from another table based on a refference column

My tables are the following

Members
Participants

Members table has the following columns:
Members[Key]
Members[Name]
Members[Active] (Yes/No) Type

Participants table has the following columns
Participants[Key]
Participants[Member] - Ref to Members[Key]
Participants[MemberActive] - (this is the column i want to call from Members[Active] based on Participants[Member])

So, basically I want to know if when the member was registered as participant, the member account value was active or inactive.