First of all thanks everyone for the help so far. This is my first stab at FM. I think it is a great program.

Now for the problem.

I am making an invoicing solution that is very specific to my business. Probably could have done it in M$ Access, but believe that FM gives me more options and looks like one I become a little more familiar with it, should be faster to finish with.

attached is a clone of my solution. as you can see, I am having a problem with the summary's in the printed invoice. I cannot figure out how to get the previous balance, overdue balance and total balance on the printed invoice.

this solution started out as the joinprint solution (thank you John Mark Osborne)

Any help greatly appreciated.

Residence_Two_Clone.zip

First off do you need to explain why you have the 5 Report month... fields almost identical in both the jointable as well as the invoice, and why you only have one TO of each table?

The RD is not an ERD, other types of relations lacks in your graph, such as non equi joins or multicriteria dito seems at least to be ignored or hidden, you should try to implement a similar arrangement to deal with your transactions, as shown in this template:

http://www.fmforums.com/forum/attachment.php?attid/4638/

...which originates from this post. ...well expand the thread and download all incarnations!

I'm afraid that the solution shown not scales particular well due to the unstored calc's grapping the previous again unstored calc'fields result ...so you need to design to make sure you won't get rid of previous transaction records, and instead implement it by utilizing Lookup Last (next lower) as seen here:

http://www.filemakerpros.com/LULAST.zip

--sd