John,

>Thanks for the reply, anyway you could supply any sample code?

Sample code to do what? Setup the ODBC connection. Create a DBC and a remote view in VFP. What do you need to do next? The data's pretty self explainatory. Accountno is the PK of the main contact1 record. Links to accountno field of all of the other tables. Child tables have a recid (or something like that) PK field.

There are a few weird things on some of the child data, but the main data is straightforward.

Contact1 stores the main data.

contact2 stores the user-defined fields under the fields tab.

Contsupp stores secondary contacts, profiles & linked docs.

Conthist stores what's under the history tab.

contgrps stores the group info. (both the group name and it's members)