I believe you when you say you can insert into a remote view from memvar -- I just can't get it to work! I keep getting the following error message:

Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'id', table 'fers.dbo.applican'; column does not allow nulls. INSERT fails.

My code looks like this:
m.id = THISFORM.appidfield1.VALUE
m.disaster = gc_dnum
INSERT INTO vapplican FROM MEMVAR
=TABLEUPDATE(.F.,.F.)

The id and disaster fields make up the primary key. They both have values but I still get the error above.

Any ideas?

Thanks,
Doug