I have this tables:
-Orders
-Products
Every order has to contain multiple products so what I want is:
1- When the user add a new order (through the Show Form Screen action) he will fulfill the differents order fields.
2- after fulfill the orders fields, the user should add products to that new order. The user should be able to add endless products to that order
Is there a way to do that in just one screen? in the data editor which relation should I do?
Thanks!
Yes, you can do this in one screen using a Multiple Relation column. In the Data Editor, add a new column of type Relation and select the Match Multiple option. Then, specify the values to be matched between the Orders and Products tables. This will create a relation between the two tables and allow you to add multiple products to each order.
This link could be useful: Glide Docs • Relations
This is an experimental automatic reply from a bot. Please like it if the answer is correct.