# How do I add multiple relations by GUI **URL:** \ **Category:** Ask for Help\ **Created:** [July 26, 2021, 6:23am UTC](https://community.glideapps.com/t/how-do-i-add-multiple-relations-by-gui/29543 "2021-07-26T06:23:34Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Peter\_Sloan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/peter_sloan/32/29254_2.png) [@Peter\_Sloan](https://community.glideapps.com/u/Peter_Sloan)\ **Post date:** [July 26, 2021, 6:23am UTC](https://community.glideapps.com/t/how-do-i-add-multiple-relations-by-gui/29543/1 "2021-07-26T06:23:34Z")
If I have a table that can point to multiple rows in another table, how do I add and delete the relationships by GUI?e.g a table of fast food restaurants that relates to a table of cities. In the table of fast food restaurants I have the columns city 1, city 2 etc ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 26, 2021, 8:04am UTC](https://community.glideapps.com/t/how-do-i-add-multiple-relations-by-gui/29543/2 "2021-07-26T08:04:07Z")
Do you mean you want to add more cities to a restaurant? ---
**Author:** ![Peter\_Sloan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/peter_sloan/32/29254_2.png) [@Peter\_Sloan](https://community.glideapps.com/u/Peter_Sloan)\ **Post date:** [July 26, 2021, 9:21am UTC](https://community.glideapps.com/t/how-do-i-add-multiple-relations-by-gui/29543/3 "2021-07-26T09:21:48Z")
yes ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 27, 2021, 12:04am UTC](https://community.glideapps.com/t/how-do-i-add-multiple-relations-by-gui/29543/4 "2021-07-27T00:04:20Z")
I believe what you want should be structured like this. **Restaurant** : Row ID, Name, Image, Description, Etc. **Cities** : Restaurant ID, Row ID, Name, Image, Etc. To have multiple cities attached to a restaurant, then when you add a new city, make sure to have the restaurant’s row ID alongside it. When you delete a row in the Cities table it will be automatically deleted from the “relation”. ---
**Author:** ![Peter\_Sloan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/peter_sloan/32/29254_2.png) [@Peter\_Sloan](https://community.glideapps.com/u/Peter_Sloan)\ **Post date:** [July 27, 2021, 2:01am UTC](https://community.glideapps.com/t/how-do-i-add-multiple-relations-by-gui/29543/5 "2021-07-27T02:01:58Z")
yes but I want to reuse the cities. I create another table that will link a restaurant and a city **Restaurant** : Row ID, Name, Image, Description, Etc. **RestaurantCityLink** : Restaurant ID, City ID, Name **City** : Row ID, Name, Image, Etc. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 27, 2021, 2:05am UTC](https://community.glideapps.com/t/how-do-i-add-multiple-relations-by-gui/29543/6 "2021-07-27T02:05:35Z")
Yes, this would work nicely! ---
**Author:** ![Peter\_Sloan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/peter_sloan/32/29254_2.png) [@Peter\_Sloan](https://community.glideapps.com/u/Peter_Sloan)\ **Post date:** [July 27, 2021, 2:15am UTC](https://community.glideapps.com/t/how-do-i-add-multiple-relations-by-gui/29543/7 "2021-07-27T02:15:18Z")
When I create the **RestaurantCityLink** I use the choice component to select the city which will set the City Id of the **RestaurantCityLink** but how do I copy the name from the **City** to the name in the **RestaurantCityLink** of make it a link? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [July 27, 2021, 2:26am UTC](https://community.glideapps.com/t/how-do-i-add-multiple-relations-by-gui/29543/8 "2021-07-27T02:26:25Z")
You would link using the IDs instead of the names, it’s much more reliable. If you need the names in that link sheet as well, make relations using the IDs to the Restaurant and City sheet and lookup to get the name.