value list not updating

[alvariux]

i have 2 tables with a common field related

in table 1 i have several values

in table 2 i have a field with a value list that take the values from table 1, when i update the field on table 1, is not refreshing the value in table 2 that is selected, i have to reopen the list and reselect the value

what can i do to update the selected value, both fields are text

thanks

[-Queue-]

If I understand correctly, you want to update the actual content of a field that is formatted to display a value list when the items in the value list change. If so, you will either have to manually change the field's value, by duplicating the field in Layout Mode and formatting it as a normal text field, then change its content in Browse Mode, or run a manual Replace Field Contents with a calculation of Substitute( textfield; "old value"; "new value" ).

You can also script the Replace or a Set Field loop, if you want to perform this action repeatedly. In this case, you can use global fields to hold the old and new values and use Substitute( textfield; globalOldValue; globalNewValue ).