i am reposting this message for more and any suggestions.

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