Chris,
You've got some good advise from Vlad.
One thing you may want to consider is looking at a framework for VFP. There are many good frameworks available for VFP. They include many features out of the box that would take you weeks or months to develop from scratch. Sure there's a learning curve and a price to pay. But IMHO it's well worth the effort. You find some useful information at the following link:
http://fox.wikis.com/wc.dll?Wiki~CategoryFrameworksHTH
>Thanks Daniel - that works! I wondered whether you have any ideas on another post I have been seeking help with. It's titled "Using Views and Adding Records"
>
>Basically I am after ideas about the best method for adding/deleting records when using a view with a base table the has an integer primary key procedure. I am not at all sure that what I am doing is good!!!
Daniel