>> snip <
>>Suggestions, please? Tho I have had years of VFP experience, this is the first application I'm writing that is not burdened by the 'old' methods of free tables (no DBC's) and 16-Bit compatibility - it's taking a little relearning to use DBC properties, triggers, views, etc.
>>
>
>I would suggest using 3 parameterized views for the 3 possibilities.

Thanks for the VERY prompt reply - after searching around on MSDN, Manuals and Help Files, and considering that the application will be multi-user, I can see how this would be best. I suspect I need to change the data source of the grid and all it's columns, or perhaps have 3 invisible grids (one for each view) and simply make the appropriate one visible at the right time.

Any experience with either of these issues?