>Problem 2
>I cant get the century to display in date fields. I have SET CENTURY ON at design and runtime. I've tried it with and without inputmasks on the table field/form textbox. No joy.

Because SET CENTURY is scoped to the current data session. That means VFP will set the default value each time you open an instance of a form. Just set it in each form Init method.

>Problem 3.
>Although I have SET DELETED ON in the application, deleted records are still displayed within the forms. By browsing the table with SET DELETED OFF, I can see that the records have been marked for deletion, so why do they still appear in my form's grid?

Same as above.

>I've scoured the documentation for answers to the above queries, to no avail. I've developed applications in several relational DBMS's in the past, but VFP is rapidly becoming the most frustrating!

Also, very rewarding when you get used to it, because:
1. The results are very good!
2. There are so many workarounds you must know and apply... that you'll never know them all. So, each day you have new challenging problems to get over... :))

Vlad