THANK YOU FOR THE ADVICE, A COUPLE MORE QUESTIONS REGARDING YOUR RESPONSES:

>There is an upfront cost of developing a C-S non-visual class. The basics will take you about 20-30 hours to complete.
Wait until you have played with the C-S before beginning writing it (obviously).

I AM ALREADY USING UPDATABLE, LOCAL VIEWS. WHAT SORT OF STUFF WILL I NEED IN THE NON-VISUAL C-S CLASS WHICH I MOVE TO REMOVE VIEWS?

>But note that since backend servers have more powerful SQL Select statements using SQL PassThru (especially for report generation) less time is spent playing with data like we usually do in VFP dbf style reporting.
out there.

C-S SQL IS MORE POWERFUL THAN WHAT I AM USING IN VFP? WHAT ARE SOME OF THE ENHANCEMENTS? WILL I NEED/WANT TO USE SQL PASS THROUGH FOR ROUTINE TRANSACTION PROCESSING, OR JUST FOR REPORT QUERIES?