I am trying to sync a field with a field in another table. OnChange I want this to happen

[Jon M3]

Here is the code I have that verifies the value is synced.  I added the if and for statement because it work 90% of the time and the other 10% failed.  I think it might be a timing issue so I added the for and if statements however now it hangs - Thoughts?

function onChange(control, oldValue, newValue, isLoading, isTemplate) {
if (isLoading || newValue === '') {
return;
}
var cc = g_form.getReference('cost_center', populateReqForDetails);

function populateReqForDetails(cc) {
for (i = 0; i < 5; i = i++) {
if (cc == 'u_cost_center_code') {
return;
} else {
g_form.setValue('u_cost_center_code', cc.code);

}
}
}

//Type appropriate comment here, and begin script below

}

[ccajohnson]

If this is client-side, I would use an AJAX call to do the heavy lifting rather than using getReference. Let us know if you need assistance in building.

[Jon M3]

Tell me more if you would be so kind.

[ccajohnson]

Before I begin, I need to better understand the end result of your design. Based upon what your subject indicates you are synchronizing records between different tables. Unsure if what you are doing is populating fields in one form from another, or if you are changing records on other tables based upon a change from the original table. I do not want to misdirect what to do if it can have a different solution.

Please let us know what you have built so far, how you expect it to work, and how it is failing so we can solution accordingly.

[Jon M3]

I have a custom field in cmn_department that I am grabbing the corresponding cost code in and inserting it if the department name is changed.