Hi @Janne
Ahhh that makes sense more knowing you want to filter by logged in user (their projects). I am a little confused by why you have a Projects column in the Constant Table, since you wanted a 1-M so you could list all the projects.
If you have in the consultants side, then you created a Many - 1, which would be the wrong direction.
I apologize if I missed something but I assumed its a 1-M from Consultant Table to Projects, where 1 consultant has many Projects. But in your ask you said you wanted to get to the Project Table in the Consultant
Table, so you could list all their projects. But it doesn't work that way. Or I am missing something.
If you could share your data model it would help.
Ask: You want a dropdown to have all the projects that a Consultant is on.
Assumption 1: That there is only 1 record in the Consultant Table per consultant
Assumption 2: you would have a 1-M from Consultants to Projects
Here you go.
I created a Table Called Consultants, with Email as the Primary Column
-I created a simple text column called Full Name
-I created a 1-M relationship to my Projects Table called Consultant, which is linked through the Email, since its the Primary column
(this shows up though on the Project table though)
I created a Table Called Projects
-I created a simple text Column called Project Title
-I created a numeric for the Project Status
-And of course the Consultant LookUp Appears
I created an App and added my new 2 tables
I have a screen with a Drop Down on it that lists my Projects.
I filter based on the logged in Users Email
Items Property =
Filter(Projects, Consultant.Email = User().Email And 'Project Status' = 0)
And with this since I am logged I only have 1 project assigned to me that has a Status of 0
Thats how you build the data model and relationship etc to Filter all Projects, assigned to a Consultant, by Email
And now you can pick any of the Projects Properties, instead of Consultant
If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others
Cheers
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
