You'll need at least three tables, one to list the artists, one to log the "micro-payments" and one to log the actual disbursement of funds (you can probably compute the split here by creating two related payment records).
You got a fair amount of design work ahead of you to do this. If you are new to FileMaker and databases, you may need to aquire some additional training via book or tutorial to get up to speed on this project.
Thanks PhilModjunk --
I've got "The Missing Manual" and I've been working my way through it, but I still can't seem to find an answer. I guess the basic problem is getting FileMaker to reognize and separate out each group of "artists." By that I mean to separate, programmatically, "Bill Jones Trio" from "Bill Munson Trio." And I cannot figure that out. It may be hidden in the "self-to-self" relationship, but it's still invisible to me. First off, I'd like to know if it's even possible to do this, so I don't waste my time or this forum's white space.
An AHA! moment. I found what I needed here <http://help.filemaker.com/app/answers/detail/a_id/3465/~/the-self-join-relationship%3A-what-it-is-and-some-examples-of-how-to-use-it>
Basically, I needed a database with the fields:
Licensed Artist (Text)
Royalty Paid (Number)
Artists Split (Calculation)
Import artist and royalty paid data from Excel spreadsheet.
Then a Self-Join relationship between Licensed Artist in primary database, and Licensed artist in joined database.
Then a Quantity Sum Field, of the Royalty paid field in the second, joined database. Voila, a total. I'm sure my terminology isn't right, but I learned enough from reading the comments here and from the Missing Manual to make sense out of the FMP site. Thanks.