>I am trying to understand what setting is different !
>
>With my Office development computer, the result of a filtered view contains all records meeting the filter requirement. i.e. with a filter of the project ID of say '000504', the result contains all records containing 000504.01, 000504.02 etc .
>
>With my Clients computer, zero records are obtained. and it is necessary to identify the all possible proj_id combinations within the SQL query filter variable.
>

What's the actual code that behaves differently between the two systems? Is this a SQL...SELECT statement, a parameterized view, or the result of a SET FILTER? On your development system, where you're presumably using the development version of VFP, there are settings stored in the registry which affect your default behavior - look at Tools/Options, the Data tab, where a number of your default behaviors are set. There are no corresponding entries in the runtime - you need to set them explicitly in your program, in some cases for each data session, if the behaviors are not the VFP default behaviors.

I run Win2K as a development platform; since my defaults tend to be different than the VFP defaults, I have a userid created for testing, where I've gone in and set all the options to the defaults used by the VFP runtime. VFP stores the information on many settings on a per-user basis - there's an entry for each user under HKEY_CURRENT_USER\Software\Microsoft\VisualFoxPro\6.0 (or 5.0 for VFP5) with the user's current defaults. This simplifies my testing procedure. I can also alter access rights and permissions for the test user id, which lets me see the effects that running as a non-privileged user will have on my application, and particularly running installation or update sets.