# Problems with Set Colum Values **URL:** \ **Category:** Ask for Help\ **Created:** [July 13, 2022, 3:39am UTC](https://community.glideapps.com/t/problems-with-set-colum-values/44380 "2022-07-13T03:39:40Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Juan\_Gutierrez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/juan_gutierrez/32/692_2.png) [@Juan\_Gutierrez](https://community.glideapps.com/u/Juan_Gutierrez)\ **Post date:** [July 13, 2022, 3:39am UTC](https://community.glideapps.com/t/problems-with-set-colum-values/44380/1 "2022-07-13T03:39:40Z")
I am creating an application to control the orders placed by each customer. What I do is the following: From the customers screen (customers table as source) I select the customer and give the option to start order. At this point I add a new line in the orders table to have the name/id of the customer. In the orders screen I select the products and I have a button to add to cart, but when I enter to create the action and use the option “Set Colum Values” I don’t see the data of the table Notes, but the data of the products I am selecting. What am I doing wrong? or how can I reference this table to feed the cart record and just update the values? If I try to do it through a relationship the button turns it off and I can not see it. thanks for your support ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [July 13, 2022, 3:49am UTC](https://community.glideapps.com/t/problems-with-set-colum-values/44380/2 "2022-07-13T03:49:09Z")
Hola Juan! Do you mean you can’t see your relation in Set Column Value action? If so, check and modify your relation, this must be a simple relation (not multiple). Saludos! ---
**Author:** ![Juan\_Gutierrez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/juan_gutierrez/32/692_2.png) [@Juan\_Gutierrez](https://community.glideapps.com/u/Juan_Gutierrez)\ **Post date:** [July 13, 2022, 3:51am UTC](https://community.glideapps.com/t/problems-with-set-colum-values/44380/3 "2022-07-13T03:51:21Z")
From customers to orders I have multiple match and from orders to customers simple, is this correct? Many thanks ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [July 13, 2022, 2:24pm UTC](https://community.glideapps.com/t/problems-with-set-colum-values/44380/4 "2022-07-13T14:24:54Z")
It looks fine. By definition: - A customer can have several orders (multiple relation) - An Order has or should be associated to an only one customer (simple relation) So far, Glide can’t write values to several rows at the same time (via a multiple relation), so we have to use only single relations. Saludos! ---
**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 13, 2022, 11:33pm UTC](https://community.glideapps.com/t/problems-with-set-colum-values/44380/5 "2022-07-13T23:33:25Z")
> [@Juan\_Gutierrez](#): > > when I enter to create the action and use the option “Set Colum Values” Can you specify what are you trying to “set” through this action? ---
**Author:** ![Juan\_Gutierrez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/juan_gutierrez/32/692_2.png) [@Juan\_Gutierrez](https://community.glideapps.com/u/Juan_Gutierrez)\ **Post date:** [July 14, 2022, 12:13am UTC](https://community.glideapps.com/t/problems-with-set-colum-values/44380/6 "2022-07-14T00:13:20Z")
Hello, Sure . What I am looking for is to assign to an order the customer id, so that when I enter the products in the cart the customer data is already entered. Why do I do this, because I need to search for the customer among hundreds of them by phone number and from the customer screen is where I can do it. The flow I follow is as follows - I look for customer (this one is in the Customers DB) - Call order (here is where I add the customer ID to the orders table) - Select my products that I want for the cart (for this I select the category, then the subcategory to choose the product, -the customer ask for this-) and here is where I have the problem, because when I want to update the cart (this is in the orders table) the Set Value is pointing to the Product table and I have no way to update the orders table. I put a video so that you can see this : [Loom | Free Screen & Video Recording Software](https://www.loom.com/share/810c864b1b6745c9bdf4b3d3fbf62b58) Many thanks for your help ---
**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 14, 2022, 12:17am UTC](https://community.glideapps.com/t/problems-with-set-colum-values/44380/7 "2022-07-14T00:17:22Z")
Some questions here: 1/Are you making the order for the customers, or are they making it themselves? 2/Can customers have multiple active orders at the same time? 3/Are customers logged in if they make the orders themselves? ---
**Author:** ![Juan\_Gutierrez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/juan_gutierrez/32/692_2.png) [@Juan\_Gutierrez](https://community.glideapps.com/u/Juan_Gutierrez)\ **Post date:** [July 14, 2022, 12:22am UTC](https://community.glideapps.com/t/problems-with-set-colum-values/44380/8 "2022-07-14T00:22:11Z")
1.- An employee is the one who makes the order for the customer who is the one who brings his clothes (it is an app for a laundry). 2.- Yes, for example you can have one or more orders for any of the categories of services provided (laundry, dry cleaning and sewing). 3.- No, the customer will not have access to generate their own orders.