I hope this time I udarstand you correctly.
SELECT PADR("yourtable",8) AS dbftype, empno ;
FROM yourtable ;
UNION ;
SELECT PADR("histable",8) AS dbftype, empno ;
FROM histable ;
INTO CURSOR crsTemp
SELECT mytable
APPEND FROM ( DBF("crsTemp"))
>Sergey,
>
>I would like to have a table name yourtable and histable attached or added as a new field in mytable at the end.
>
>yourtable.dbf and histable.dbf have only 1 field and both have same structure
>empno#
>10000 yourtable
>20000 histable
>
>mytable.dbf when append from yourtable and histable should have 2 fields
>
>dbftype empno#
>yourtable 10000
>histable 20000
>
>dbftype have 8 characters like DOS filename, the fact behind this is to get
>the filename added to mytable. dbftype C(8), empno C(5)
>
>TIA
>Paul
--sb--