>Is there any way to copy the entire contents of a record in one table and put it into a remote table? I have a situation where I have a table on a network in Texas and a table on a network in California connected by a T1 line. When one of the table records are changed I need the other to change also. I know SQL passthrough will work with ODBC. However, I have many fields that are involved in the record.

Steven

This works with free tables.
SELECT table1
SCATTER MEMVAR MEMO
SELECT table2
APPEND BLANK
GATHER MEMVAR MEMO

If you are using cursors try it. Then issue a TABLEUPDATE() on the 2nd cursor.
Basically you store everything into menmory variables. Then insert them into the 2nd cursor.

HTH
Mike