I'm unable to wrap my head around this. I have a database which handles publishing contracts and books, and am trying to handle a single payment that is split between multiple authors (who may have written a book together).
I've attached a quite simplified version of the database, which seems to be working correctly except that when I try to calculate the payment due to each author, I get no result. I do need these many to many relationships as multiple authors write multiple books together (or not) which are included in multiple contracts with multiple payments, etc.
The desired result is in the "author payment" field in the portal on the layout "final", for 500 to appear for Adam, and 600 to appear for Elizabeth and Marianne.
I'd be quite grateful if someone could take a look at this and let me know what I'm missing.
Thanks in advance,