How to properly use table relation, pivot table, and relation manager
To help others find answers, you can mark your question as solved via
Right click solution message -> Apps -> ✅ Mark Solution