Create a new record on a different table on clicking a ui action

[Prakash43]

Hi, I have two custom table, table1 and table2 . Table 2 is child of table1.
I have a ui action "Fill Form" on table 1 on clicking of which i want a new record to be inserted in table 2 .
But it is also creating a new record in table 1 which i don't want 
How can i achieve this any help would be appreciated
Thank you.

Code which i am using on ui action:

var gr=new GlideRecord("table2");
{
gr.initialize();
gr.fields=current.fields;
gr.insert();
}

[Prakash43]

Hi Ankur this is the complete script which i am using

var ans=new GlideRecord('u_filled');
{
    ans.initialize();
ans.u_owner = current.u_owner;
ans.u_list_field = current.u_list_field;
ans.u_choice_1 = current.u_choice_1;
ans.u_choice_2 = current.u_choice_2;
ans.u_choice_3 = current.u_choice_3;
ans.u_question_1 = current.u_question_1;
ans.u_question_2 = current.u_question_2;
ans.u_question_3 = current.u_question_3;
ans.u_question_4 = current.u_question_4;
    ans.insert();
    action.setRedirectURL(ans);
}

[Ankur Bawiskar]

Hi,

are you sure there is no BR on u_filled table which is inserting data again into your current table

update script as this

var ans=new GlideRecord('u_filled');
ans.initialize();
ans.u_owner = current.u_owner;
ans.u_list_field = current.u_list_field;
ans.u_choice_1 = current.u_choice_1;
ans.u_choice_2 = current.u_choice_2;
ans.u_choice_3 = current.u_choice_3;
ans.u_question_1 = current.u_question_1;
ans.u_question_2 = current.u_question_2;
ans.u_question_3 = current.u_question_3;
ans.u_question_4 = current.u_question_4;
ans.insert();
action.setRedirectURL(ans);

Regards
Ankur

[kumaril1]

Hi Try below script

var gr = new GlideRecord("u_table2");
    gr.initialize();
    gr.setValue('u_tb1',current.u_t1);
    gr.setValue('u_tb2',current.u_t2);
    gr.insert();
    action.setRedirectURL(gr);