Hi all,

How to get a filename while appending the records from mytable.dbf ?

select mytable with two fields
dbftype empno#

append from yourtable && contains only empno# field
append form histable && contains only empno# field

in order to have at the end in mytable two fields :

dbftype empno#
yourtable 10000
histable 20000

Please help in coding.
TIA
Paul