>Is there a way to have dbf1 have dbf2's structure appended to it?
>thanks.
Aside from reading the structures and doing an ALTER TABLE, you coudl try using COPY STRUCTURE...EXTENDED. Try:
USE DBF1
COPY STRUCTURE EXTENDED TO TEMP1
USE DBF2
COPY STRUCTURE EXTENDED TO TEMP2
USE TEMP1
APPEND FROM TEMP2
USE
CREATE DBF3 FROM TEMP2
USE DBF3
APPEND FROM DBF1
ERASE TEMP1.DBF
ERASE TEMP2.DBF
You'll need to filter out any duplicated field names, but this should give you a starting point.