How to insert new record while reference another record using background script?

Vijay Kumar21
Tera Contributor

Hi Team,

We are trying to insert a new record in table 1 using background script, This new record needs to be referenced with another table (table 2). 

The issue is new record is getting created but the reference field is empty.

 

var order = "3243211";
 var net = new GlideRecord('table1'); 
 net.addQuery('id', "21"); 
 net.query(); 
 while (net.next()){ 
 var netInfoID = net.number; 
 var gr = new GlideRecord('table2'); 
 gr.initialize();
 gr.order_id = order; 
 gr.network_info = netInfoID; 
 gr.network.setDisplayValue(netInfoID); 
 gr.setWorkflow(false); 
 gr.insert(); 
 }

 

find_real_file.png