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.