Using data Master/Detail

I have two data type variables.
One with the event and one with your guests.
I define the most recent event by the date comparison. The closest to today.
In element 0 I have an id. Where I specify this id for the data variable filter the guests.

EVENTS
Id
Name
Date

GUESTS
Id
IdEvent
Name

Hi,

When the event is chosen, you can use the formula SELECT to filter the guest list, so that the selected event’s Id matches the guest’s IdEvent. Here’s also a tutorial video on filtering data, if that would help.