>to all
>i have a two grids master & child. master/transaction type. each master record links to multiple records in transaction grid. master record keyed on id#, transaction records keyed on (id# + trans#). anyhow both are in keyed sequences. i added a textbox at the bottom of the grid column containing the field i want to total. i use the following code:
>
>hold = masterid
>SUM trans.amount TO THISFORM.TEXT1.VALUE FOR trans.masterid=hold
>
>it takes forever, wherever i put it, ie afterrowcolchange or i just put it behind a click on a command button, it doesnt matter where i put it, it simply takes an unacceptale amount of time to total.
>
>
>the master table contains 1800 rcds.
>the trans talbe cotains 30,000 rcs.
>
>each master can contains about 30 transaction records.
>
>am i using the wrong code to do this...
>help...
>suggestions please
>thank you
>frank

Probably, you tried it correctly, but widespread implicit usage of non-filtered cursors may pervert many xbase commands. The safe way to work with grids, including your case, is to base each of them on completely independent cursor (view). Here, xbase code still works Ok.