Steve,

Re #4 below: Sorry, I meant in the rel_orders table, not 'gennotes'.

Re #6 below: No, you do not need a TABLEUPDATE() if the tables are UNbuffered, which I presume they are since things work normally.

Just trying to have as much relevant info as possible in the thread in case it twigs some other reader to a situation they've had.

regards


>1) Is rel_orders part of the m2mdata.dbc?
>No it is not, it is a free table.
>
>2) Does jomast.dbf have any memo fields in it? If so, it might make a difference to add MEMO to the SCATTER.
>Yes it does have memo fields
>
>3) Is gennotes in rel_orders (look like it is) and more importantly is gennotes a MEMO field?
>Yes gennotes is a memo field.
>
>4) Are the following ALL of the fields in gennotes?
>- drawingnum
>- fcustpono
>- gennotes
>- fgroup
>- finumber
>Im not sure I understand the question. Gennotes is a memofield that is the same as soitem.fdesc with carrige returns and extra spaces removed.
>
>5) Does rel_orders have any field default values or triggers or other stored procedures that might act on it when INSERTed?
>No not at all.
>
>6) Is it correct that there are no later TABLEUPDATE()s or that TRANSACTIONS are in use?
>That is correct, I just open it, zap it, append records and close it.
>Should I be using tableupdate?