One List, three tables?

[maxinic]

GOOD MORNING
In the usual example Author Books, I added a list Buyers.
The three lists are connected as in image1
With the left join and the related data I can see the list author join with books. Click on add, enters into the form and add books buyer.
Can I see all three tables simultaneously as in Image2?

 

[Jaanus]

GOOD MORNING
In the usual example Author Books, I added a list Buyers.
The three lists are connected as in image1
With the left join and the related data I can see the list author join with books. Click on add, enters into the form and add books buyer.
Can I see all three tables simultaneously as in Image2?

Perhaps it's possible with Fabrik content plugin.

But usually, you see all 3 table's data in one list, not as 3 separate lists

 

[maxinic]

thanks for the answer
but as it does with the content plugin?
I'll show you the content plugin for example, the authors list but then I see no buyers, then how do you show the blank row below where you can inseire data?
at least take me on the right track

 

[maxinic]

why i don't see all 3 tables in one list?

 

[maxinic]

perhaps I get the error
All left join must be made on authors list
so,
left join authors with books + books left join with buyers
on the same edit list author?

but now I've done
edit list authors with books left join
then
edit list books left join with buyers

Cen you confirm that all the left join should be made on the same list?

 

[troester]

Yes, you must add a second join to authors list.

 

[maxinic]

thanks,
and as regards the view as in immagine2?

 

[troester]

You can add the "inline edit" list plugin to your authors list.

But this plugin is work in progress, it has still bugs and I don't know if it's working on joined lists.

I think the better way is to set "ajaxfy links" in your list options, then clicking on the "Add" button above your list will open an empty form in a popup window.