Riley,

I don't use MM, so if there's an MM-way of doing things, then don't listen to me <g>, someone else may have a better answer.

First, how are you getting your data from Table A and Table B to begin with? Are you putting it into a DataSet? If so, it's easy enough to iterate through the DataRows in your MyDataSet.Tables("TableA") (or MyDataSet.TableA, if you're using a Typed DataSet) and then add DataRows to the "B" table, MyDataSet.Tables("TableB").

Then update the DataSet as you normally would.

Or am I missing the point of your question?

~~Bonnie




>Table A holds parent records.
>Table B has children.
>
>At specified invervals controlled by the user (button click), portions of table A need to be copied to table B (as in a batch posting routine).
>In VFP I would select the records from table A into a cursor and scan through it doing an insert into table B. Even with sql back end.
>
>Now what do I use for a cursor and scan loop?
>
>Do I construct a sql statement that performs an insert from a select as a stored procedure?
>
>Any help is appreciated. Type slow though I'm sorta dense.