Hey!
Finally reached the level where I ask the forum what I cant understand myself.
I have a database of Projects.
This contains a list of Bookings.
This contains a Assignee.
This is a User.
I’m trying to populate a RG with the Projects where the User is assigned to a Booking.
When I search for all Projects, no problem.
But all my efforts to Constraint or Filter this is been out of luck.
Here is what my logic tells me:
“Search for Projects”
Contraint “Booking contains Search for Bookings(Assignee = Current User)”
But this leaves me with a list of Bookings in the constraint, which faults the data.
If I do :first item or :item# I get it to work with only one Project, but I want to list all the projects.
Anyone has a great plan for how I can achieve this?
Thanks