Hi everyone!, first question here.
I have been checking this community frecuently and found lots of solutions to problems I have been encountering.
My problem Its quite simple, I guess I am missing something obvious otherwise it would be a big limitation which would already be addressed…
The situation: I have a base with many products, each product is linked to some clients. Example
Product 1: Client A, B and C
Product 2: Client B
Pruduct 3: Client A and D
Like this I have at the moment 200 products, but soon this will grow quite a lot.
The problem is that when I have a new client, lets call it “Client E” and I want to link it with 50 records, I have to write his name in each record, I cannot just click on the small square and drag it all the way around. If I do so, it will just copy the value of the inital record (with all the initial linked values) in all the ones that have been draged.
At the moment I am doing it manually, but I guess it shuold be possible to do it automatically, or at list faster.
The desired outcome, How can I add the linked record “Client E” fast to the records so that they would look like:
Product 1: Client A, B, C and E
Product 2: Client B and E
Pruduct 3: Client A, D and E
Thanks all for the support!