Retrieve participation status of a guest to an event (when several events exists)

Yes you need another datatype Participation with fields for Event and Guest

That allows you to do searches for a specific guest and get all their events and vise versa

Very similar to this: