# Something is horribly wrong

**URL:** <https://community.glideapps.com/t/something-is-horribly-wrong/13101>\
**Category:** Report a Bug\
**Created:** [July 25, 2020, 10:24pm UTC](https://community.glideapps.com/t/something-is-horribly-wrong/13101 "2020-07-25T22:24:18Z")\
**Posts on this page:** 1\
**Showing post:** 16

<div class="post-metadata">

**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:** [July 26, 2020, 7:52pm UTC](https://community.glideapps.com/t/something-is-horribly-wrong/13101/16 "2020-07-26T19:52:33Z")

</div>

In that case I’d have a sheet for the product, a sheet that lists the product id and the accessory id, and then a sheet to list the accessories. So basically there would be a crosswalk sheet in the middle. In that case I would create a multiple relation from the products sheet to the crosswalk sheet. Then I would create a lookup column to get an array of all related accessory id’s from the accessory id column in the crosswalk sheet. Then I would use that lookup column to create a relation to the accessories sheet. That last relation is what you would use to show a list of accessories in the product details. Of course that method uses many more rows compared simply creating an array column with only 10 accessory options. But we are building a airplane, soooo…

---

_[View the full topic](https://community.glideapps.com/t/something-is-horribly-wrong/13101)._
