Within same Doctype Copy of Fields from one Child Table to another child Table

[amsrk]

Doctype A
Child Table 1 (Link field x; Trigger Field xx)
Child Table 2 (Link field y; Comparison field yy)

1. When the trigger field xx is updated
2. Check in table 2 for row where x=y
3. For row x=y ; copy yy to xx

The following reference is not working:

HOW TO: Fetch Child Tables

Everyone: I’ve updated this tutorial on my website, which is much better than what is below. I’m leaving the old one as is here, as it is referenced in subsequent posts. You can click this sentence to go to the article. Expand for original post:

Fetching Child Tables DocTypeA = Source DocType (The document that holds the child table you are getting values from DocTypeB = Target DocType (The document that the values are going into ChildTableA= Source Child Table ChildTableB=Target Child …

[amsrk]

This solved the problem, handled the case as part of validate.

frappe.ui.form.on(“DOCTYPE”, {
validate: function(frm){
frm.doc.items.forEach(function(item){ //Target Table
frm.doc.hardwareset_bom_mapping_table.forEach(function(hsbom){//Source Table
if(item.hardware_set == hsbom.hardware_set) //Matching/Comparing field in Source & Target
{
item.bom_no = hsbom.bom; //Source table field copied to Target field
}
});
});
}
});