If you have the dataview of the company place a data grid Tender inside. Then use a datasource microflow to retrieve all the tender object where the reference matches the company.
So, let's see if I get your setup correctly.
As I read it, there is no relation between Company and Tender, correct? If that is true (and intentional), there is no way to directly get a Tender for a Company.
Either you can get to Tender via InvitedCompany:
InvitedCompany_Tender/InvitedCompany/InvitedCompany_Company = $Company
(pseudocode, obviously) should yield a list of tenders. Not a very clean solution though, it seems.
Better alternative seems to be to also create an association between Company and Tender, so you can easily retrieve
There should be a relation between Company and Tender. Maybe I've got the relations mixed up. The purpose of the InvitedCompany "Table" is to connect Tenders with those Companies that have been invited to the Tender. To bad it is not possible to attach a image of the model....
In addition to the previous mentioned relations there are two more between Tender and Company:
Tender_Company *_1 [Buyer] Tender_Company *_1 [Broker]
The association works as I can display a table of Invitations including the associated Tender and Company. What I'm trying to acheive is in SQL an innerjoin - how do I do that using a microflow?
Thanks :) Fredrik