Hi @salvadaor ,
I have tried to do this ( I believe from your description, that I had a very similar situation except for materials and storage locations) and it is not easy (the automation).
For my use case, I created a third table which links to both and keeps tracks of specific quantities of materials in each location.
Depending on your use case, the following video may be helpful. However, I use the third table to update, through linked records, the Materials and Storage Location tables, or in your case the Clients and the Representatives. Then you only have to update 1 table.

https://www.youtube.com/watch?v=8BWm5dO1awU
If you find another, I would be very interested to know what type of automation you used, but unfortunately I got stuck so I had to do this work around.
Hi @salvadaor ,
I have tried to do this ( I believe from your description, that I had a very similar situation except for materials and storage locations) and it is not easy (the automation).
For my use case, I created a third table which links to both and keeps tracks of specific quantities of materials in each location.
Depending on your use case, the following video may be helpful. However, I use the third table to update, through linked records, the Materials and Storage Location tables, or in your case the Clients and the Representatives. Then you only have to update 1 table.

https://www.youtube.com/watch?v=8BWm5dO1awU
If you find another, I would be very interested to know what type of automation you used, but unfortunately I got stuck so I had to do this work around.
HI @Ella11 - unfortunately I don't think this is the solve I needed as it's a slightly different use case. I think my trouble is that I have both clients and representatives in the same table (because they're fields for contacts) whereas your materials and locations are in separate tables. I'm going to keep working on it to see if I can find a workaround because I know there must be a way