>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?
Place a
in front of the code. This will preserve your code layout
Have you packed your memo field? Also you might take a look at the hacker's guide, it gives a pretty decent explanation of the memo file.