Good evening,
I have an application where people can post reviews of games, a bit like letterboxd for those who know. All you have to do is enter your five-star review, with the option of bookmarking it, and so on. The only problem is that I want to add comments that people can leave under each game.
The problem is that when I add the comment function, it gets mixed up between all the games.
Let’s say I leave a comment under the game Minecraft. My comment will also be visible under GTA V, Red Dead Redemption, … (basically all games)
Is there a way to separate each comment for each game? Give people the chance to give their opinion only for THE game they want and not have everything mixed up?
Did you have separate table for Commrnts?
It would have:
Game ID| User ID| Comment text| Stars
And you need to add multi relation from game table(game ID) to Comment table Game ID. And add comment collection with source of this rel
The relation in your user table probably isn’t necessary unless you have a specific reason for adding it.
When adding a comment, make sure all of the columns in the comment table are getting filled. You should see the relation in your game table get populated for each comment for each respective game.
Finally make sure that the comments collection is sourced from that relation.
I totally understand what you’re saying, but I have no idea how to apply it.
Would it be possible for you to give me the steps for example? If you don’t mind?
Or I’ll invite you to my glides
Honestly, I’m still stuck on what I sent earlier.
I still don’t quite understand the relation between the tables etc.
I tried to do what the comments above said to do, but well.
The relation seems fine, but I would make sure to check the ‘Multiple’ checkbox because you will have more than one comment I assume.
Relations look for exact matches so as long as you are writing the GameID (RowID from Games table) to the comments table, then you should have exact matches between the game RowID and the ID written to the comments table.
