select multiple rows from one table, and paste certain data to one row in another table

[Marko_Nesic]

Hi,

what is the way to do this?

I have an inventory table with products, and one table with shipment orders. Is there a way to select several products, and set an action to take some of data from them and create one new row in shipment table

thanks

[TeeSee1]

One way to do this is to create an action of type below.

You can apply this action to multiple rows by using this Checkbox icon

Then select rows to apply this action to and press the action button.

[Marko_Nesic]

That is what I was looking, but that will insert as many rows as i select, but I need only one

[TeeSee1]

you mean combine multiple product rows into one shipment row?

You always select the same number of products?

What are the relations between products and shipment?

[Marko_Nesic]

you mean combine multiple product rows into one shipment row? Yes

You always select the same number of products? No, it depends, from 1 to max 5 rows

What are the relations between products and shipment? There are no relations

[TeeSee1]

what is/are the combined data from products to shipment?

numeric values like total weight?

some kind of a list (product name)?

[TeeSee1 · Accepted solution]

One possible way if you just want to SUM a numeric field

[Marko_Nesic]

Thanks You , that will work out. Super