Hi Peter

Sorry for replying late.

>Personally I'd consider merging all these DB's into one and adding KeyField CompanyId, Int, as Identity where applicable.
>...
>A. Build your reporting views, not in VFP but at the backend, thus letting the server do most of the work.
>
>B. Build VFP remote views to facilitate updates.
>
>If you already have a VFP interface you could pass the companyname as a parameter at startup, declare the parameter as public and in your VFP
>remote views add:

Thanks for your viewpoint.