>>> 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?
Since it sounds like all 3 views will have the same fields and just parameratized differently, use 1 grid. When you need to change the Grid.RecordSource:
Grid.RecordSource=SPACE(0)
Grid.RecordSource=myview2
Grid.Refresh
HTH
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.