i made a formset with a data environment and grids.
from sad experience, i decided to use sql statements
in the second form.

my problem is, they don't update at once. is it the
buffering in the formset?
1. tried turning it off to default data session but
still, data does not update.
2. with buffering on, i tried tableupdate() and still
no bite (got an error also).

i kept reading on buffering, bufermodes and cursors
created for the form but no clue on my problem.

here's a sample code :

* get the current highest job_id from realcodes
select jobid from realcodes into cursor temp
* increment for next job id
lnrealJobid = temp.jobid + 1
* cursor clean up
use in temp
lsJobgrp = this.txtJobgrp.value
* insert the values
insert into job (jobid, pseudojobid, jobgrp) ;
values (lnrealJobid,
val(this.txtpseudoJobID.value, ;
lsJobgrp)
* update the real job id value
update realcodes set jobid = lnrealJobid

the update doesn't seem to take place on the realcodes
table. this causes indexing error on next entry because
real job id has old value, giving next entry same value
as in the child table.

many thanks in advance.