I have a "Person" table that has birth date. On another table, I lookup that birthdate to find the person's current age when "Event" happened. Next year, a new "Event" will have different age for the person (as they are a year older). But I need to k...

I've got a table with People informationNameGenderEthnicitySallyFemaleBlackJohnMaleWhiteMarkNon-BinaryWhiteAnd a table with events:EventDateParty2022-01-02Service Project2022-02-03And a third table with lookups that pair people with events:Master Lis...