Hello there.
I’m creating an app where we have projects, and on each on thems we have a comment app.
I have a database created for the chat system, and a relation between the chat database and the database of each project.
I can see data is stored on the good way, but it’s not showing off the data, and I don’t get why…
You are comparing the RowID for rows in the project table to RowID for rows in the chat table. They will never match. Relatione only work if they can find matching values between both tables.
You need to store the Project RowID in a new column in the chat table and use that column for your relation.
Thanks for your quick answer, that’s really appreciate. I also find it weird, follow this step by step guide on youtube
But yes… Logic was not getting on me…
So, I created a new column in the Chat table and make a relation with the Project database. Do I need to delete the column in the project table?
You probably don’t need a relation in the chat table.
What you do want is a relation in the Project table linking it’s RowID to the project row ID stored in the chat table. When a new chat row is added, it should be filling in a project Row ID so you know which project each chat row belongs to.
I will not have find it Myself I think so.
Thanks a lot for your help, it have been really helpfull.
If I can do anything for you (review etc..) Feel free to ask it