Very Computer

--
Posted via CNET Help.com
http://www.help.com/

Here's a way to accomplish what you're trying to do.  I'm assuming you've
used the "define relationships" feature to establish a relationship from
cases to payments, and again from payments to cases, based upon a unique
field like Case Number:

In your Payments file, create a summary field called Total_Paid.  Check
"Running total" under the options for a summary field.

Now create a calculation field called something like Still_Owed, using the
following formula: cases::amount owed - Total_Paid

Create a list layout in payments with the Still_Owed field on the same line
with Date_Paid and Amount_Paid, etc.

In your Cases file, create a script which uses the step "goto related
record" with "show only related records" checked.  This will pop you over to
the payments file with only the payments for this case file listed.  This is
critical so that your Total_Paid field sums the correct set of records.

I ran a quick test, and this works like a charm.

Hope it helps,
Ron

Quote:> I have created an accounts collection database using two database files in
> Filemaker Pro ver 5.  The first file we will call "cases" and has the
> general information on my cases, eg client name, date of loss, amount owed
> etc.  The second file we will call "payments".  This records payments made
> by the debtors.  The fields in this file include date of payment, type of
> payment, form of payment (checks, etc.) and amount of payment.  I am
> trying to write a formula in the payments database to appear as the
> balance due after every payment using the following fields:  amount owed
> (pulled from the cases file; date of payment; amount of payment and
> balance due.  At some point I would like to incorporate an interest
> factor. I hope I have made myself understood because this has been driving
> me crazy.
> Tony

> --
> Posted via CNET Help.com
> http://www.help.com/