There’s one table which holds a bunch of addresses, say Address, against some town.
There’s another ‘persons’ table.
What I want to do is to assign a person against a bunch of addresses which share the same town name.
I have made another ‘link’ table, which has a column named town, which is a valid if from the address table - Address[Town]
There’s another column which shows all addresses against the same town.
Then there’s a person column which is a ref from the person table.
What I want to achieve is to write the person name in the address table against the addresses which are chosen here.
I know that is achieveable by using a referenced action on the rows of the address table. The referenced rows would be the ones that match the addresses with the ones chosen here in the link table.
But I don’t know how to write the person name into that table. If I use a data change action, then I cannot figure out how to use the person name there, which is dynamic and dependent on the link table column.