I have defined a connection to a Pervasive database and created remote views for most of the database tables, except for a troublesome few that have too many fields for VFP.

To deal with those troublesome tables, I'd like to create two remote views for each one where view has half of the fields including the primary key.

Is there a way to accomplish this and include each view in the DBC so they can be used transparently as if they were views created with the VFP IDE. If not, how do I create them programmatically?

TIA,

Alex