Razzak, Thanks for the lead.. I traced through the code of the menu form and the sale form.. I see in the menu where you are also creating a unique transaction ID to put with each sale to set up entry to the form and then you have an eep firing on the exit of qty field to recalc the totals after each line. This is pretty close to what I am doing, except my problem is my data in the region is not a single transaction so to speak.. It is a single table (no header/detail) and all of the lines in the table are completely unrelated to each other..So I did create a transaction ID to put with each line to help create a selectable condition to sum. But where it gets tricky is when I have multiple users adding and editing the data at the same time. It's probably just an issue with the logic in my coding. Unfortunately this example in RRBYW8 does not have an edit option/form for me to trace and get ideas from. I will keep working on it,and of course if you want to add the "header/footer" idea to my Christmas wish list :)
-- Frank -- Frank Taylor, Systems Network Administrator -- F.J. O'Hara Corp, Boston, MA -- [EMAIL PROTECTED] - 617-790-3093 -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of A. Razzak Memon Sent: Monday, February 21, 2005 4:15 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Sum of Scrolling Region At 03:56 PM 2/21/2005, Frank Taylor wrote: >.. I have a form that has a scrolling region on it.. I wanted to show >the user the totals at the bottom of 2 of the fields in the region.. Frank, Take a look at the "Sales Order" form (Running R:BASE Your Way! Part 8) with Invoice Header, Line Items as Order Details (in Scrolling Region) and Sub-Total, Freight, Sales Tax and Invoice Total as Sales Order footer at the bottom of the form. Database: RRBYW8 Form: SalesOrder Command File: RRBYW8.DAT Process: RRBYE8 | Main Menu | Sales | New Sales Order ... Follow the entire Sales Order routine and see how Sub-Total, Freight, Sales Tax and Invoice Total are calculated dynamically at the bottom of the form. Hope that helps! Very Best R:egards, Razzak.
