HI Bernie Now my table structure is Custnum Date Amount Charges are + and Payments are - A the end of the day I do a Sum(amount) and update the balance in the Patient file.
I have seen other programs that seem to work this way Custnum Date Charge Payment Balance 101 1/1/04 $50 $0 $50 101 1/1/05 $50 -$20 $80 So, the second line must take the balance from the first line, add the charge from the second line, subtract the payment on the second line to get the $80 balance. I know how to do this in a spreadsheet but I do not have any idea how to do it in RBase or if it is even possible. It really is not a big deal, I was just wondering it this way has any advantages to my way. Marc ----- Original Message ----- From: "Bernard Lis" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, September 01, 2004 1:54 PM Subject: [RBG7-L] - Re: Form calculation > Sounds like you have a one to many relationship here. > One original charge and many payments. > In this case I would make a separate payment table consisting of an Invoice > No. and payment amount and perhaps payment type (check, credit card, cash), > etc. > then on your form you could show the original charge and in a region show > the payments, and the final balance due. > How about adding an ageing - 30 60 90, etc. > Hope this helps, if not perhaps you could explain more about your > application. > Bernie Lis > ----- Original Message ----- > From: "Marc" <[EMAIL PROTECTED]> > To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > Sent: Wednesday, September 01, 2004 2:31 PM > Subject: [RBG7-L] - Re: Form calculation > > > > Hi Bernie > > > > That part makes sense but how do you get the > > formula to use the Balance from the line above, > > then add the next lines charges - the payments. > > > > Marc > > > > > > > Marc, > > > If a value is changed, place a bit button on your form with caption > "Save > > > Changes", create an eep that does a saverow. Put a hint in, that says > "If > > > you made any changes, click here to update" > > > Then refresh the form. > > > Bernie Lis > > > ----- Original Message ----- > > > From: "Marc" <[EMAIL PROTECTED]> > > > To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> > > > Sent: Wednesday, September 01, 2004 8:47 AM > > > Subject: [RBG7-L] - Form calculation > > > > > > > > > > HI all > > > > > > > > Is it possible to have a forumla something like a spreadsheet > > > > in a region. > > > > > > > > I want something like this > > > > Charge payment Balance > > > > $50 $0 $50 > > > > $50 -$20 $80 > > > > > > > > and if you changed one of the payments or charges the balance > > > > on that line would be re-calculated and all of the rows below > > > > as well. > > > > > > > > I can figure out how to do one line but I can't figure out how to > > > > include the Balance form the line above. > > > > > > > > Thanks > > > > Marc > > > > > > > > --- RBG7-L > > > > ================================================ > > > > TO POST A MESSAGE TO ALL MEMBERS: > > > > Send a plain text email to [EMAIL PROTECTED] > > > > > > > > (Don't use any of these words as your Subject: > > > > INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, > > > > REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) > > > > ================================================ > > > > TO SEE MESSAGE POSTING GUIDELINES: > > > > Send a plain text email to [EMAIL PROTECTED] > > > > In the message SUBJECT, put just one word: INTRO > > > > ================================================ > > > > TO UNSUBSCRIBE: > > > > Send a plain text email to [EMAIL PROTECTED] > > > > In the message SUBJECT, put just one word: UNSUBSCRIBE > > > > ================================================ > > > > TO SEARCH ARCHIVES: > > > > Send a plain text email to [EMAIL PROTECTED] > > > > In the message SUBJECT, put just one word: SEARCH-n > > > > (where n is the number of days). In the message body, > > > > place any > > > > text to search for. > > > > ================================================ > > > > > > > > > > > > > > > > > > > >
