Paula OConnor

Thanks, guys. I'm getting closer : Now I'm getting them in the correct order, but for some reason my sales report is not showing up correctly. The only thing I'm getting is the 1st line entry & then a grand total at the bottom. I'm sure it's something about the way my report is set up, but it looks correct in Filemaker & when I print it out. Anyhow, I'm going to keep trying. Thanks so much for all the help!

The reports are in the same database, but different tables and layouts.

The main report is the cover letter, which includes the names and addresses of all of our royalty recipients. The cover letter is related to each of the other reports by the PAYEE field. So I guess the "if" would have to deal with that PAYEE field? Each payee will have a cover letter, but the script would have to do something like this... Say the 1st cover letter is for JOE BLOW... Then it would have to go to the CD Sales report, and if there's a JOE BLOW in that one, it would be placed after the cover letter... Then it would have to go the the next report (Digi sales) and look for JOE BLOW there. If there is no report for JOE BLOW in that one, it would have to move on the next report... And so on. Like I said, some recipients will have all of the reports and some will just have a couple of them, but they will all have that cover letter. Once all of the reports are checked, then it would go back to the cover letter again & start with the next PAYEE. I hope that makes sense! :

I hate to keep bugging you about this, but since you offered... LOL I work for a smallish music publisher & we are getting ready to start our annual royalties. Normally I print out all of the cover letters & reports separately & then manually match them up. This is exactly what I have: 1- A Cover Letter table with about 500 payees 2- A report (actually, it's a detailed statement) on CD Sales 3- A report on Digital Sales 4- A report on Additional Licensing, etc. 5- A report on Deductions They will all receive a cover letter, but they do NOT all receive all of the reports. Some only have CD sales, only a few of them have deductions, etc. The one field that they all have in common is the PAYEE NAME. The cover letter and all of the reports are together in one database. I think that about covers it. :

Thanks for taking the time to do that. I think my poor little script-deprived mind understands this one. However, I came across a major issue that I didn't think of before... Each payee will not have all of the reports. They all have the same cover letter, but the rest varies. Therefore, without some kind of script telling it to match the reports with the cover letters by PAYEE, I don't think it'll work. I really do thank you all for your help with this. I guess I just have to be satisfied with one report after the other! :

This is what I have now (which just lists them one report after the other)... Go to Layout ["Cover Letter"] Show All Records Sort Records [Restore] (sorting by Payee) Save Records as PDF Go to Layout ["Sales Royalty Report by Payee"] Show All Records Sort Records [Restore] (sorting by Payee) Save Records as PDF [Append] and so on for each report... How/where would I add a loop to that to make it group them all by Payee?

I'm not really familiar with scripts, so I'm having a hard time understanding exactly what you mean (especially about the loops), but I'm going to keep playing with it this morning. Thank you so much!

I have just upgraded to Filemaker Pro 9, mainly because of the "append to .pdf" feature. However, I can't seem to be able to figure out how to append the reports in the order I'd like. I have several tables, all with the PAYEE in common. One is a Cover Letter, one is a report on Product Sales, one is a report on Digital Sales, etc (some of the reports are multiple pages for each payee). How would I write a script that would sort them by PAYEE... Cover Letter, then Product report, then Digital report, then the next PAYEE, and so on, instead of just all of the cover letters, then all of the reports, one by one? I sure hope I'm making sense here! : I'd appreciate any help!

Yes, but you made it very easy to understand, so I'll have no problems with the rest of it. Thanks again!

This is great! Thanks so much for going through all that trouble :

Awesome ~ Thanks so much for the help!

Thank you so much for your trouble, but I think maybe I'm not explaining it correctly. I've attached a shortened version of my table to show exactly what I need. Take CD# 142 for example. The total foreign amount we were paid for that CD was 97.07. That amount was shared by 2 artists. Therefore, the foreign amount (97.07) is listed 2 times. What I need the foreign total column to do is take the repeating CD#'s & just give me the amount paid for that particular CD, not add the 97.07 plus 97.07, etc. In other words, I need a calculation that will take the foreign amount paid for each CD & divide it by the number of repeating CD#s. And now I probably made it even more confusing! : CopyAce.zip

: Let's see if I can explain what I need... I work at a music publishing company & we receive royalty payments which are shared between us, the writers, other publishers, etc. Many times the payments are made per CD, but are then split many different ways, therefore it is never a set amount of entries for that one CD. My question is this: Is there a calculation that would figure out the total amount paid PER CD, without adding up each payment per person? Here's maybe a less confusing example: CD #1004 (may have 10 entries for a total of $50 for that one CD) CD #1005 (may have 20 entries for a total of $100) Is there a formula that would add up just $50 plus $100 & not add $50 or $100 per entry? Thanks in advance. It's probably simple - I just can't seem to figure it out!

Worked like a charm! THANK YOU so much!!

Hi! I'm using Filemaker for our music royalties and use the following tables: Sales Royalties Digital Download Royalties Foreign & Additional Royalties They are all related to a table called "Artist Information" which has our artist's names and addresses. My question is this - I have the Artist's name linked to each table, but is there any way to set it up so that if a name isn't entered into a royalty table exactly as it appears in the "Artist Information" table, it will let me know there is an error? I'm sure there's a technical term for what I'm asking, but I don't know what it is and probably wouldn't understand it anyway. So if there's anyone who can answer me in "dummy language", I'd really appreciate it!