This can definitely be done in FileMaker, but creating such a database requires two areas of expertise: 1) You need someone who understands the business practices and what tasks the databas needs to be designed to support. 2) you need someone who understands how a database system like FileMaker should be designed to meet the needs of 1). One person can wear both hats, but more often, a database developer has to sit down with the client who can describe what they need.
You'll need to sit down and very carefully figure out on paper what you need from the database. You've made a start here, but additional details likely need to be filled in here.
Just focusing on what you've described, you need three tables: Authors, Titles, and Author_Titles.
Authors---<Author_Titles>----Titles ( ---< means "one to many" )
Authors::authorID = Author_Titles::AuthorID
Titles::TitleID = Author_Titles::TitleID
You'd enter information specific to each author in the authors table. information specific to each Title in the Titles table. Author_Titles serves as a "join" table so that you can multiple Authors to one title record to document multiple authors for one title and multiple titles to one author so that you can access a list of all titles for that author.
Some data like royalt % will have to be considered carefully. If all authors of a given title always get the same royalty percentage, then this field should be defined in Titles. If different authors of the same Title can have different royalty percentages, then this data should be defined in the join table so that you can record a different percentage for each match of author to title.
Thanks for your help! I have lots of planning thinking to do, and this is a very helpful start.
You might look at the White Paper for Filemaker Novices.
There are an increasing number of videos about Filemaker on Youtube
The Missing Manual series is good, I own several.