Last week I was plugging away at a problem and realized that I probably could use a good book on 'general' VFP stuff. Let me give an example to illustrate:

I have a grid that is bound to a view. The first column in the grid has a checkbox as the control which is bound to a field in the view. Occasionally and regularly the users complain that the checkbox does not respond to a mouse click to change its state. If they press the space bar or press , it responds. I can reproduce it every now and then on my dev machine but not consistently.

So I look through the properties sheet thinking 'am I missing one little setting here that is needed?'. Also, 'should I bind the field to the column or to the checkbox' because it seems to work both ways. When I look up ControlSource in VFP help or the 'Hackers Guide', they sometimes help but often they just give info on that particular property or method. What I could use is something that says 'if you are going to use a view bound to a grid, then set these 5 properties blah, blah' and then some insider's tips on the way NOT to do it - eg. 'Always bind the control source to the textbox/checkbox and NOT to the column because we have generally found that to be problematic'.

Another example: If the view has the fields in the same order as the grid (eg. first 6 fields in the view are first 6 columns in the grid), it works to just set the record source to the view and set RecordSourceType to 1- Alias. This seems to work but maybe people have found it to be problematic over time. I noticed that I form I did about a year ago when first starting in VFP was set like this - it always seems to work. But now I am more inclined to set the record source for the table but also for each control within each column.

So you can tell I like to blather on....the question again is (other than the Hackers Guide which I have) are there any books that go into detail for each control and list all the best ways and pitfalls to which properties should be set when using the control in different ways?

Albert