# Creating a view for 1 to many to many relation **URL:** \ **Category:** Ask for Help\ **Created:** [February 7, 2025, 1:57am UTC](https://community.glideapps.com/t/creating-a-view-for-1-to-many-to-many-relation/79857 "2025-02-07T01:57:28Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Burlington\_Landscape](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/burlington_landscape/32/84886_2.png) [@Burlington\_Landscape](https://community.glideapps.com/u/Burlington_Landscape)\ **Post date:** [February 7, 2025, 1:57am UTC](https://community.glideapps.com/t/creating-a-view-for-1-to-many-to-many-relation/79857/1 "2025-02-07T01:57:28Z")
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. ![Screenshot 2025-02-06 at 8.52.20 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/0/e030fafbc0a4b30dd41437ddd51af403402f6021.png) ![Screenshot 2025-02-06 at 8.53.28 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/c/7ce84be135f896c817dc9240c58a1634ed2d7dc3.png) I do not see the correct relation. Thank you ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [February 7, 2025, 2:14am UTC](https://community.glideapps.com/t/creating-a-view-for-1-to-many-to-many-relation/79857/2 "2025-02-07T02:14:39Z")
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. ---
**Author:** ![Burlington\_Landscape](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/burlington_landscape/32/84886_2.png) [@Burlington\_Landscape](https://community.glideapps.com/u/Burlington_Landscape)\ **Post date:** [February 7, 2025, 2:26am UTC](https://community.glideapps.com/t/creating-a-view-for-1-to-many-to-many-relation/79857/3 "2025-02-07T02:26:15Z")
Thank you will give that a try !