AnsweredAssumed Answered

How can I duplicate records for both primary database and related database?

Question asked by jiang_aq on Jan 24, 2018
Latest reply on Jan 24, 2018 by beverly

I am a newbie and  from non-english speaking country, allow me get start from example to express my question:

 

For example:

 

Table A (Primary datebase):

Field1 Field2

001     car

002     ship

003     airplane

 

Table B(related database, which I used in the  portal):

Field1 Field2

001      Mike

001      Jessie

001      Sue    

002      Peter

002      Jack

....

 

How can I script to append one new record copy from TableA::Field 1 002 record, meanwhile, append new records duplicated from two 002 records in Table B? Like below:

 

TableA:

Field1 Field2

001     car

002     ship

003     airplane

004     ship

 

TableB:

Field1 Field2

001      Mike

001      Jessie

001      Sue    

002      Peter

002      Jack

003      Peter

003      Jack

 

Thank you in advance!

Outcomes