Fetch data from a DocType's child table to another's

Frappe Framework Custom Script
11 
frappe.ui.form.on('Solicitud de Remision', {
    id_de_la_cirugia: function (frm) {
        if (frm.doc.id_de_la_cirugia) {
            frm.clear_table('in_sol_rem');
            frappe.model.with_doc('Cirugia', frm.doc.id_de_la_cirugia, function () {
                let source_doc = frappe.model.get_doc('Cirugia', frm.doc.id_de_la_cirugia);
                $.each(source_doc.consumos, function (index, source_row) {
                    
                var addChild = frm.add_child("in_sol_rem");
	             	addChild.importe_unitario = source_row.importe_unitario;
		            addChild.des_sol_rem = source_row.descripcion;
		            // add as many fields as you want
		            frm.refresh_field('in_sol_rem');
                });
            });
        }
    }
});

Make sure the field types match for both child tables to map them

5 Likes