AnsweredAssumed Answered

Copying some data from one specific record into a record of a different table

Question asked by MarcCalders on Dec 19, 2010
Latest reply on Dec 20, 2010 by philmodjunk

Title

Copying some data from one specific record into a record of a different table

Post

Hello,

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.

Example :

Table 1 : "Recipe", data: pancakes

Table 2 : "Recipe ingredients", data1: flour 100g, data 2 : sugar 50g, data 3 : milk : 500cl, ...

Should become

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,

Marc

Outcomes