Update value list
I have two tables that are related. A field 'Community' from table2 uses the values from the field 'Community' from table 1 as input.
My problem is that when I am making adjustments to the community name in Table 1, this community name in Table 2 does not get updated automatically. How can I change this, and thus make sure that the valuelist consisting of the Communities of table 1 gets automatically updated?