>>>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.
>
>thanks that worked except instead of CREATE DBF3 FROM TEMP2
>you wanted CREATE DBF3 FROM TEMP1

I know - I posted a correction a couple of minutes after this...