>>You could also "COPY STRUCTURE EXTENDED" for each DBF you are using and the APPEND the extended structures into one file.Then issue a create from to create one DBF.
>>
>Interesting. I wondered what would happen with duplicate field names so I tried it copying 2 structure extended tables from the same original. All the fields from the second table had a 2 at the end and underscores between the original name and the 2 to pad them to length 10.
>
>Regards,
I have noticed that with VFP 6 and "select" from a DB table. When the first 10 letters of the fieldname are the same, it puts a sequence at the 10th position.
If that is an issue, you could programtically loop (or seek) through the prospect "structures" and delete them.
Imagination is more important than knowledge