I’m trying to call a value from another table based on a refference column
My tables are the following
Members table has the following columns:
Members[Active] (Yes/No) Type
Participants table has the following columns
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.