I'm building a website where users can register and view their latest project updates. I have already created a custom member area by creating members database.
I have created another database called Projects such that I will upload project details and status for each user to view.
I have set "Email" as the main field in both "members" and "projects" database. Each database has dynamic pages connected to it as well. What I want to achieve is based on the logged in user/email of members dataset the information of projects dynamic page would be displayed.
My question is, how can I connect "members dataset" and "projects dataset" in a dynamic page of projects database?
I have wrote a previous thread asking about how to connect two dataset together and got a reply by using reference field or use the filter option. I have tried both options but it's not working for me, or am doing it in the wrong way, could anyone help in explaining the best way to achieve my goal? would it be better to use coding instead of the two other options?