Hey George,
Doh! I need more coffee before I start responding. You are completely correct. Thanks for the clarification.
>The above probably won't work. APPEND FROM requires a file not an alias name. Further, if a filtered representation of the table is created (which it probably will be), there won't be a file other than the original, so the original problem may remain. So...
>USE networktable IN 0 SHARED
>SELECT * FROM networktable INTO CURSOR foo NOFILTER
>lcfile = DBF('foo')
>USE IN networktable
>SELECT localtable
>APPEND FROM (lcfile)
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05