Given the following relationship
Users → Worklists → Properties ,
1 User has many Worklists
1 Worklist has many Properties
I would like to display all properties for a single user. How should I do it and what should the data look like.
I do not see the correct relation.
Thank you
Assuming you already have all of your relations set up…
Create a lookup in the user table to retrieve an array of all worklist IDs from the the user->worklist relation. Then create a another relation linking the lookup array to the properties table where I assume you have a worklist id on each property row.
Thank you will give that a try !
