# Many-to-Many Relationships **URL:** \ **Category:** Ask for Help\ **Created:** [November 20, 2019, 11:37pm UTC](https://community.glideapps.com/t/many-to-many-relationships/2225 "2019-11-20T23:37:17Z")\ **Posts on this page:** 1\ **Showing post:** 14
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [November 23, 2019, 1:28pm UTC](https://community.glideapps.com/t/many-to-many-relationships/2225/14 "2019-11-23T13:28:54Z")
@Mark and @david BTW I originally was going to use the unique ID feature to make the link relationship on the Attendees spreadsheet but realized that it wouldn’t work for this many to many style of relationship because of the choice component. When adding an attendee to an event either from the participate detail side or the event details side of it, both need to use a choice component to select the other side of the relationship, and since the choice component only allows you to select on column, using the Unique ID column would be useless. See my post about an enhancement to the choice component: > [@Choice Component - allow key display pairs](https://community.glideapps.com/t/choice-component-allow-key-display-pairs/581): > > In the interest of some kind of data normalization and using key links in your tables/sheets it would be nice to display pretty text for the choice dropdown but save a key value to the database/sheet. This is more in line with how it is implemented in HTML which is what is ultimately driving things under the covers. This is the idea I’m talking about. The user would see the long text but the save would be the shorter. All that you would have to do is allow the user to optionally select a sec… --- _[View the full topic](https://community.glideapps.com/t/many-to-many-relationships/2225)._