AnsweredAssumed Answered

Copy records between portals

Question asked by paolobkk on Dec 3, 2010
Latest reply on Dec 7, 2010 by philmodjunk

Title

Copy records between portals

Post

ok this is a bit complicated,

I have 4 tables:

"incoming invoice" - with a primary ID key related to "stock bond" (ID = invoice number)

"stock bond" - with a primary ID key related to "line from bond" (ID = nr entry in bond)

"line from bond" - with a foreign ID key coming from "line from bond" as described above and also with another foreign ID key coming from "transfer orders" (ID transfer)

"transfer orders" - (mentioned above) with a primary ID key related to "line from bond"

I have a layout from "incoming invoice" with a portal for the "stock bond" and another layout from "transfer orders" with a portal from "line from bond".

When I make a new "transfer order I need to copy all the items from the portal of "incoming invoice" layout (table: stock bond)  to the portal in the "transfer order" layout (table: line from bond).

After few days of trying and scripting I still can't get it to work, perhaps somebody have some ideas?

Thanks Smile

fm.jpg

Outcomes