>In the form that the class is positioned, there is a relation ship created from parent table to child table. As a record in the parent table is selected, the corresponding related records are available for the grid based on the child table. Since the table is buffered (5), the action on the form can Add or delete records to the Child table. These are not committed until a later stage. However, the forms action will depend on the remaining records that show up on the Grid. So when I try to look back and count records etc in the Child Table I am only getting the original records before the Adding and Deleting action occurs. If I do a Tableupdate, life is wonderful, however, I am looking at a means of being able to report back to the form the resulting number of records and let the form do the commitments as far as tableupdates etc. If I could get the count from the buffered area would be great. But everything I try gets back to the original.
Ronald,
How are you looking back? If you select the work area and use commands like SCAN/ENDSCAN, COUNT, SUM, etc. then you should get the buffered data.
If you use SQL statements then you won't because it uses the underlying table opened in a new workarea and this wouldn't have the new changes. This is also true if you open the alias again under a new alias manually.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao