I need to duplicate certain columns from a foundset. I need to do this for multiple tables in the relation
What is the best way of doing this ?
I want to do something like this …
for(i in selected_pk)
{
var pk = foundset.selectRecord(selected_pk[i][0]);
var dupFoundset = foundset.duplicateFoundSet();
foundset.newRecord();
foundset.pk_id = pid;//from sequence
foundset.a = 'xx';
//fill in remaining columns from dupFoundset
foundset.x = dupFoundset.x ;
foundset.y = dupFoundset.y ;
//etc ....
}