>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

IMHO Mandy,

For simple views use the View Designer. For more complex views, use CREATE VIEW... where you attach your (pretested, I hope) SQL code.

I use ad hoc SQL statements for things like populating combo boxes from AllCodes, and views where the same complex SQL-Select is used repeatedly (usually parameterized). It's a judgment call, and others may feel differently.

For example, Visual MaxFrame suggests views for ALL data entry, using tables ONLY for lookups.

Barbara