Relational Database Help
Hi, I'm needing to design a database that will take sales information for books and associate a royalties amount for each author. I have no real idea how to go about doing this, so I am yielding to the experts.
One table (or separate database??) will have Title, Author, Total Units, Permissions, Royalty % and Owing. The other table will have all the info (Address etc) for each Author.
The end result I need is a report that has the author's name, and the calculated royalty % they are owed. Another complication is that some authors have written more than one book, and some books have more than one author.
Not sure if this helps, or if it can be done in FM.