Back again. I forgot to ask for your thoughts on creating local views. Unfortunately the books I have don't have much info on creating them even though they appear to be a valuable tool in VFP.

What's your opinion about the best way of creating local views... hard coded SQL statements (and where do you create/store them?) or using VFP's View Designer?

Also, any ideas where I can find more info on creating "complex" views here on the 'net?

MTIA,
Mandy