We have a customer community set up, and we are sharing custom objects based on a lookup to account. We created a sharing set - selected the correct profile and then we added sharing based on user.account = customObject__c.Account__c
Now on the same custom object we have an other lookup to account to specify a third party and we want to give users which belong to that account also access to that same record.
But it seems that this is not possible without creating a new profile, which of course we want to avoid as much as possible. Otherwise a user who have access to his own records and records linked to the other lookup would need to switch profiles before viewing the other records.
This question was asked here four years ago. Is there a way we can handle this now.One profile with a sharing set that looks at 2 lookups.