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.
Is there a way we can handle this in a more elegant way? One profile with a sharing set that looks at 2 lookups.