>Hi there,
>
>If the tables have the same structure all you need to do is :
>
>
>FileList=adir(SmallTable_xx.dbf)
>
>&& For 1 Record Only .... Put it in a loop if you want it for more the one
>&& record
>
>Select "TableYouWantToExtractDataFrom"
>SCATTER TO USEFULDATA && Copies the current record to Variable USEFULDATA
>
>For Each SmallTable in FileList
> Select "TableYouWantTOPutDataIn"
> If EOF()
> Append Blank
> Endif
> GATHER FROM USEFULDATA && Paste the record which was copied
>Endfor
>
>Hope it served you for some help

Franco,
Original question is not mine :)
I appreciate your trial. Thanks.
Cetin