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

}

[Jon M3]

Also they are not the same field - cost_center is a string of the name - u_cost_center_code is the number that represents the cost_center - the people using this deal with numbers

[ccajohnson]

This sounds more like they want to search on a cost center number rather than the display value of the cost center. Is this correct. There is no need to create some synch mechanism when what you want is to use an auto completer. Using your field from the cost center table as an example, place the following into the Attributes section of your reference field:

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_cost_center_code,ref_ac_columns_search=true

[Jon M3]

That is correct - so I would put that code on my custom u_cost_center_code field?

[ccajohnson]

My guess is that you have a reference field that points to the Cost Center table. If that is correct, you should be able to go to the Dictionary Entry of that field and go to the Advanced view. From there you can add the appropriate Attributes:

[Jon M3]

Here what I have - I have the OOB department table which shows the display value of Cost Code (it is a reference to the Cost Center table).  I have a custom String field that I have put on the form called u_cost_center_code which was put there to synch to get the actual code for the displayed Cost Code.