What you are describing will be more complex to set up than you might first think. An author can write many books and since authors collaborate on books, a book can be written by more than one author. This will require setting up a Many to Many relationship in order to make that work.
Start with these relationships:
Authors::__pkAuthorID = Author_Book::_fkAuthorID
Books::__pkBookID = Author_Book::_fkBookID
You can place a portal to Author_Book on the Authors layout to list and select a Books record for each given Authors record. Fields from Books can be included in the Portal to show additional info about each selected Books record and the _fkBookID field can be set up with a value list for selecting Books records by their ID field. And you can place a portal to Author_Book on the Books layout to see all authors credited with writing that book as well.
To make the above work, you'll need to learn how to set up relationships, portals and value lists. Scripts are also often needed to make it easier to add new authors and/or new books and link them in with a matching Author_Book record at the same time.
Well, that is a lot to process, but is much welcome!
I will dig into it as soon as possible, and will likely come back with a few more questions ;)
I have the Lynda.com series about FM12, and I think there's a part about relationships and a bit of scripting too, so I guess I'll start there. Any additional resources on this particular issue that I should read/watch?
Thank you so much, you're being most helpful.
You can examine this demo file that I set up for illustrating different layouts and scripts for working with many to many relationships: https://www.dropbox.com/s/oyir7cs0yxmbn6i/ManyToManywDemoWExtras.fp7
You can open this file by using Open from FileMaker's File window to convert the file to the .fmp12 format.