People ,

I have a couple of tables which has a datasession set to 5

One table is the parent table who has one primary key
and one candidate key ,
i append blank the parent table and put on purpose a valua in the candidate key field that already exists.

then i do an insert into the second table and then i get an errror
that the canditate key field in the parent table has violated(
because i put a value that already existed) ,

What i don't understand is this ,
If i put my buffering to 5 i should be able to control the
tableupdate but it seems like because i do an insert into the second table it triggers an tableupdate in the other table

how can i resolve this problem or has anyone an eplanation of this
problem

thanks,
david van der Vliet
Holland