Yes, this can be done. The XPath in the Brand selection widget would be something like:
[Brand_Company/Company/Campaign_Company = [%CurrentObject%]]
**EDIT**
I built a small example. I think your domain model should look like this
I changed the highlighted associations from what you posted.
Next I created this page to enter information
And finally, I created this page to enter Campaigns
The brand autocomplete is configured like this
And here is a video of this solution working
https://watch.screencastify.com/v/JyhkwLLfYZMXfHOHJF1i
Hope that helps.
It’s looks like I cannot use [%CurrentObject%] this widget (zabawa = module name ofc) or I’m doing something wrong :/