Hi John.

>Are you familiar with Accpac?. Can I add table fields to their data sources (Pervasive) through VFP?

You can add fields to Accpac tables using VFP but you shouldn't; you could risk data integrity in Accpac. Instead, create some new tables in a different database (could be Pervasive or even VFP) and use VFP to join the data from the Accpac tables and the other database similar to the original queries you posted.

Doug