How to refresh field contents from a value list when value list changes?

[milefaker]

I have a table Subjects containing a list of unique values in field SubjectName. This field serves as a the value list for populating a field SubjN in a second table Articles, which is related to Subjects.

My problem is that when I make changes to the values in SubjectName, the corresponding contents in SubjN do not refresh. Is there an automatic way to refresh them?

There is a different field in Articles that populates automatically depending on the key that relates Articles to Subjects, so I have used only a value list for SubjN.

Thanks for your suggestions.

[bcooney]

From your description, the Subjects table should have at least two fields, SubjectID and Subject. Then, any table that you wish to relate to Subjects would have a foreign key field, _kF_SubjectID. So, if the text desc Subject changes, you'll instantly see the new text desc in all related tables.