I've had some weird behavior issues in the past (not exactly this one) and I've all but cured them by adding reccount() before my insert commands. Like:
select mytable
=reccount()
insert into mytable (fields) values (values)
Does that have any effect for you?
You don't, by chance, have the same table open multiple times under multiple aliases do you?
Brandon Harker
Sebae Data Solutions