Hi...
I could use some expert help here...

Please note the following code...
CREATE TABLE &cLocalDB FROM ARRAY aFlds

nSelect = SELECT(0)

SELECT MAIN
GO TOP

DO WHILE NOT EOF()
SELECT (nSelect)
APPEND FROM &cNetDB FOR Mainkey == MAIN.Mainkey
SELECT MODACAD
SKIP 1
ENDDO

The idea is as I loop through the main database
MAIN I can find the matching records for each mainkey
and append them into a local copy of the data.

Even if there is no mainkey's in the table I append from (cNetDB)
the FPT file becomes very huge (like 420 MB)

In some cases...

The question is why?