There are ways to handle this ... looping and duplicating, exporting then importing etc but I need to understand the purpose behind the request to properly advise. Usually if there is only one field which would change then it is going against general relational theory and could best be handled with a related table or potentially a multiline in that single field. It will also help to understand your FM version here.
We work with relational tables in this way:
Product1 Product type 1
Product2 Product type 2
And we have a report this way:
Product Description Machine
Product1 Product type 1 145
Many times, a new product goes throught the same machines except one or two, so I want to copy the machines of the product1 in table 2 and paste again in the table 2. Then just write the "Product2" in the first field.
Dificult to explain.....
We are working with approach and now we need to change and we are testing diferents databases
You shouldn't need to copy any data from table 1 to table 2 to get the report you need.
I suggest at least three tables for this:
Products (table 1) ----<Production>-----Machines (---< means one to many )
Products::ProductID = Production::ProductID
Machines::MachineID = Production::MachineID
With this structure, you can use Production to log what product (and how much, and on what date/shift) is manufactured on a specfic machine.
Your report can be a summary report created with a layout based on the Production Table. Fields from Products and Machines can be added to this layout in order to provide additional information such as the product description field.