Furthermore, if you, for example, have a view as a RecordSource of the grid, and then modify your table, changing the field name in the table and in the view, - VFP will crash on the REQUERY() of that view. You can spend hours trying to figure out what is wrong with the view, but the real reason is that you forgot to change the field name in the Column.ControlSource. :)
Nick
>Hi Robin ---
>
>Grids are sensitive blokes. Did you change or delete any of the fields associated with the grid? I have seen them blank for those reasons.
>
>
>>I have a small app that has three related tables. I had created 5 pages and on one of them was < Detailed Activity > in a grid. I have a button to go to the detailed screen to modify/add to the activity. I modified the structure of the database and now the grid shows no data. I changed one of the linking fields to a primary key with one to many. Why did this cause the grid to show no data at all?? I tried removing and re-adding my environment on the form.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison