1 Reply Latest reply on Jul 26, 2011 12:32 PM by philmodjunk

    Can any one give me tip?



      Can any one give me tip?


      Hello Peep's

      i am creating a database, here are the details

      i'm giving bike on installment to my 1 customer, for example, bike cost is 20000 $, 

      now on file maker pro, i made few edit box with Label: Installment 1, 2 & So on, now what i want is that, i put 20000 $ in box then i fill Installment boxe's as customer pays to me, but i want when ever i fill installment field, it auto decrease amount from Total Cost

      like, Total Cost: 20000 $

      Monthly installment is 200 $

      now i put in Installment 1: 200 $

      after i put price and press Enter, i want that it auto decrease 200 $ from Total cost & make it 18000 $

      thing is simple but needs few words to xplain, which formula / method can be used, help with pics will be appreciatable, brief answer too can help me

      thank you!

        • 1. Re: Can any one give me tip?

          Use a related table of payment records linked to the record that records the sale of this one item. (Don't know structure of your databse, but this is likely a lineitem record filled via a portal to line items on an invoices layout.)

          Each time you receive a payment, create a new payment record and record the amount and link it to the correct item sold. A sum calculation can total up the payments so that Sales Amount - Sum ( payments::Amount ) will compute the balance remaining. One fairly simple way to set this up is to use a portal to payments on a layout based on LineItems.

          Before you try to set that up, you may want to examine this simple invoicing demo file to see if a set like it uses is what you have or perhaps what you can modify your database to support. It doesn't show recording payments like this, but does show the basic invoicing set up that I recommend you start with before trying to add the ability to record payments like this.