Copying some data from one specific record into a record of a different table
I need to the data from one layout (2 tables as layout + portal) into 2 different tables by changing the name which links them together.
Table 1 : "Recipe", data: pancakes
Table 2 : "Recipe ingredients", data1: flour 100g, data 2 : sugar 50g, data 3 : milk : 500cl, ...
Table 3 : "RD Recipe", data: copy of pancakes
Table 4 : "RD Recipe ingredients", data1: flour 100g, data 2 : sugar 50g, data 3 : milk : 500cl, ...
I've no idea how to do this in FM Pro; I've tried duplicate record (but doesn't allow me to change the data), import / export (don't want to change all data) and how to approach the portal information.
Thanks for anwering this issue,