>Edward, I appreciate your advice. I am new to VFP and I'm not familiar with VIEWs/Cursors. Are you saying I should set up a view in the view designer with the two files and use that view in the grid?? I would like to get on the best path as I am beginning a project and would be grateful down the road.
>
>Tim
There are couple questions which sould be clear up when project starts.
1. How big is data you going to put in the grid. The bigger data is the more attention should be paid to query (in a case of view/cursor) speed. There are some workarounds how to increase speed dramatically.
2. Will users edit/add data interactively, i.e. directly in grid cells. If 'Yes' then View is becoming a preference, if 'No' you can opt to use Cursor which is faster.
3. Will users have 'Cancel All Changes' functionality. If Yes then optimistic-table buffered view is necessity.
Edward Pikman
Independent Consultant