# Editing a Multi Relation **URL:** \ **Category:** Ask for Help\ **Created:** [July 16, 2023, 2:18pm UTC](https://community.glideapps.com/t/editing-a-multi-relation/63972 "2023-07-16T14:18:35Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Ralf\_Westphal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf_westphal/32/61695_2.png) [@Ralf\_Westphal](https://community.glideapps.com/u/Ralf_Westphal)\ **Post date:** [July 16, 2023, 2:18pm UTC](https://community.glideapps.com/t/editing-a-multi-relation/63972/1 "2023-07-16T14:18:35Z")
Here’s puzzle I cannot seem to solve: - There are tables Tasks and Clients. - Each task can serve several Clients (1:n). - In Tasks I set up three columns: clients (the names of the clients as foreign keys; if multiple then comma separated), clients\_arr (the names of the clients as an array), clients\_rel (the multi relation to the table Clients linked to clients\_arr. This setup is working nicely when adding a new task: ![Bildschirmfoto 2023-07-16 um 17.07.33](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/3/4356b703fdbe3366da37c5ba8c92d3917b9890d0.png) (translate “Bewohner” with “client”) But when I edit a task it’s looking differently: ![Bildschirmfoto 2023-07-16 um 17.07.55](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/4/44d6275180c3fb9a6b7bb1148467f06f532aaf4d.png) I only see the selected clients. That’s ok, as long as I don’t want to change them. The settings for the Choice component are like this: ![Bildschirmfoto 2023-07-16 um 17.13.46](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/0/c01647bf5848e778e9674faa939644b301abb87b.png) (translate “Bewohner\_rel” to “clients\_rel”) Since the component is bound to the multi relation column only the selected clients are shown. Great. Or not. Because how to select an additional client? I can remove a client by clicking on it, but i cannot add another one. When adding the Task I see all clients from the table and can select the relevant one. But when editing I cannot bin the component to the table. Then all clients are shown - but the ones selected are not highlighted like when adding a Task. What am I doing wrong? Where is my understanding lacking? I’d like the edit screen look like the screen for adding a Task (first image). Any ideas? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [July 16, 2023, 2:21pm UTC](https://community.glideapps.com/t/editing-a-multi-relation/63972/2 "2023-07-16T14:21:35Z")
Use your Clients table as the source of the choice component, instead of the relation. ---
**Author:** ![Ralf\_Westphal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf_westphal/32/61695_2.png) [@Ralf\_Westphal](https://community.glideapps.com/u/Ralf_Westphal)\ **Post date:** [July 16, 2023, 2:31pm UTC](https://community.glideapps.com/t/editing-a-multi-relation/63972/3 "2023-07-16T14:31:28Z")
Thanks! Yes, that works. 🥳 But strange, nevertheless, because that’s what I tried first - and it did not work. 🙄 I’m very sure. Hm… Anyway. I’m happy it’s working now. Sorry for bothering you. ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [July 16, 2023, 2:43pm UTC](https://community.glideapps.com/t/editing-a-multi-relation/63972/4 "2023-07-16T14:43:43Z")
> [@Ralf\_Westphal](#): > > But strange, nevertheless, because that’s what I tried first - and it did not work. 🙄 I’m very sure. Hm… Is it possible that you may have had it targeted at the wrong column? (that would explain the behaviour that you saw) > [@Ralf\_Westphal](#): > > Anyway. I’m happy it’s working now. Sorry for bothering you. No bother at all. Happy to help 🙂 ---
**Author:** ![Ralf\_Westphal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf_westphal/32/61695_2.png) [@Ralf\_Westphal](https://community.glideapps.com/u/Ralf_Westphal)\ **Post date:** [July 16, 2023, 2:56pm UTC](https://community.glideapps.com/t/editing-a-multi-relation/63972/5 "2023-07-16T14:56:23Z")
> [@Darren\_Murphy](#): > > Is it possible that you may have had it targeted at the wrong column? (that would explain the behaviour that you saw) Maybe. Don’t remember. But now I know that it’s working as expected - when done right 😉 ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [July 17, 2023, 2:56pm UTC](https://community.glideapps.com/t/editing-a-multi-relation/63972/6 "2023-07-17T14:56:56Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.