Display link between A and B table in C table


I have tables Client (table A) and Clients items (table B) with link relation. I would like to show this link relation as a list in table Invoice items (table C) with filter to specific client (variable depends who I am going to invoice for). Is that possible or is there any other simple solution?

I think you would need to create a “middle man” model for that.

Hi, in my opinion, you should download tabidoo Custom Data Source extension (for Reports & Widgets), create a data source where you relate fields using filters. Then you can use the custom data source within Widgets or Reports by selecting the name of the data source you created.As if you used the classic view in a database ones relating the desired fields.You should find within the documentation explanation. Greetings.