I am new to databases so this will probably be a dummy question!
I have Users who can create Events.
Users can mark certain Events to save to their Favourites.
I created a column for “yes/no” in the Events datatype.
The “save to favourites” button is set to add “yes” to the current event (see below)
and the “view my favourites” repeating group is set up as below:
I realised after setting this up that if one User adds an event to their favourites, ALL users will see the same favourited event! I am not sure how best to show a favourited event ONLY to a user who favourited it.
Do I need to create a new datatype and link them or something?