I saw a very strange bug when you insert in a child window (you have a relation from the current dbf to the one in which you insert). This was in FPD 2.6. I couldn't replicate the problem, but I saw it in a given environment. Nothing helped and I'm almost sure it was a bug. The solution was to replace the INSERT with APPEND+GATHER.

Vlad

>i need to add records to 4 tables. all are open and belong to the same dbc. i've set a couple of variables for fields and generated a unique id for identification.
>
>for 3 of the 4 tables, everything works fine. on the fourth, nothing happens. no errors, but no new record. code is:
>
>insert into po_cgms!pubs (appl_id) values (lnAppl_ID)
>
>this is the same code i use for two of the other tables (table name changed, of course) and those two work.
>
>any ideas?
>
>
>btw, has anyone else checked out the newest forum?