>I found at least part of my problem, I was trying to do a COUNT FOR and it was moving my record pointers around. I am going to try a SQL instead. Is there any good FAQ's or white papers on using parameterized views? I have read a lot of messages about it but I have never used it myself.

There is probably something here in the knowledge base- but the VFP docs explain it pretty well too. If you want a broad picture of how p-views fit into an application architecture, I suggest buying a VFP book (www.hentzenwerke.com).



>I have trouble getting views to work, I get everything just the way I want and then when I try to save it in the designer I get some error about can't find a specific field that I know exists. Thanks for the help.

This is not a problem with views, but with the view designer. It is a well known bug that causes the designer to choke on anything more than a 2 table view. Alternatively, you can create your views by hand using CREATE SQL VIEW. This takes care of everything except setting the several properties needed to make you view updateable. For this, you'll need to look into DBSETPROP(). Or save yourself a bunch of trouble and download my alternative to the view designer, "eView". You can get it here in hte files section.