This sounds like your relationship is not based on a meaningless, auto-generated ID, but the name itself …?
Do you have info about the relationship and the value list setup?
It seems you are setting values in a field using values in another table instead of displaying the names from the related table directly in the Layout. This is the nature of the value list in FM. If you use a relationship and use the actual edited name field in the layout it will always display correctly. But the layout design has to change to make it work with the relationship. Why are all the contact names in a value list? Maybe it is a filtered value list for only people related to a certain class, ok.
Since your design is using a value list to set a field, once the field is set it stores the value from the value list at that time. There are ways to make the updates. As with many things in FM there are a few way to do this. How often do you need the values to update (do you make a lot of changes)?
The two ways that jump out at me are use a script trigger to set the fields again every time an edit is made to the contact record or use merge variables on the layout to display the correct data. A virtual value list could be a part of this, but I do not think it is required.
For the merge variables, basically you use a script or a calculation to keep $$name set to the actual current value in the contact record. This is used for display only and are just text on the layout as <<$$name>>.
Using a script trigger to set the fields on edit should be straight forward.
Depending on what exactly you are doing you could try to find ways to not have the name entered in both tables. This is really the best idea. You could use they drop down as a selector that filters a portal that shows only the data form the selected contact record. Let the relationships work for you and stop doubling data.
Thank you bigtom.
This is exactly what I needed. I have now got it working. Thank you again.
Thank you siplus.
Really appreciate the file. Together with bigtom's explanation I have now got it working perfectly. Thank you again.
You were correct. erolst.
I get it now so thank you for your help.