LOOKUP values from this column in the last meeting for this club

[StephenMattison]

Howdy!  In my Meetings table, [Pick Roles] Initial Value, I need to LOOKUP the values entered into [Pick Roles] from the last meeting scheduled for this club, many clubs will schedule many meetings. My Key column is _ComputedKey.

I have a Meetings table. In the [Pick Roles] EnumList column, User will pick which meeting roles need to be filled while scheduling the next new meeting.  The list of Roles to be filled will mostly remain the same from meeting to meeting,   but will need to change occasionally. So when scheduling a new meeting, I want to set the Initial Value of [PickRoles] to the same as it was for the last meeting, for that club. Then user can add or remove roles as necessary when setting up the next meeting.  TYVM!