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.
filter(“Address”, [Town]=[_THISROW].[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.
Maybe it’s just too early in the morning, but I can’t make sense of what you want to do.
It’s okay @Steve, I got you; grab some coffee mate!
So you want to modify the address table records based on the values from your link table?
That goes against standard practices; your address table should stand as just that - addresses. You’ve already gone the correct route and create a link table to connect everything together.
If you make all the columns in your link table ref columns (to each respective table), you’ll end up with a related list of link records on each of those tables. So on your Addresses table, you’ll have a list of all the link records associated to that address - which would show the people you selected.
You could use a list dereference to pull a list of names from that.
Or maybe just the presence of an inline view listing all the associated names would be enough inside your app.
User | Count |
---|---|
45 | |
29 | |
24 | |
22 | |
13 |