Filter by dropodown

[maxinic]

Hello to all
I read several threads about this topic but I do not understand how to do.
I have the two famous list "Authors" and "Books"
authors
id, name, etc.

books
id, title, authorid .

I wish that appear the names of authors in the dropdown.
User choose the author, and appear the list with all his books with the + button to add another book for that author.

If I understand it, I should add an item with the content plugin where I put the form Authors above and the list Books below . But how can I display the field name as a dropdown, and not as a record to be added?

 

[maxinic]

Suggestions?

 

[troester]

There are several ways to do it.
In any case set the authorid element to be a databasejoin element to author
a)
Set the authorid element to be dropdown filter
-> the books list will show the author dropdown filter

or b)
edit author list, enable "Related data" list + form
-> the author list will show a link to related books + a link to add books

or c)
edit author list, add a join to books list (id to authorid), set Repeatable=yes, display mode=merge
-> editing (viewing) an author will display all his books, too

 

[maxinic]

Thanks Troester I understood the concept. Now I hope to hear applied to another database a little more complex