Dustin,
>If I use SQL passthrough, will it update the data?
Yes...in actuality, remote views are really a "wrapper" around SQL Passthrough...VFP just does the SQL Passthrough for you. Using local and remote views can be simpler than using SQL Passthrough, but SQL Passthrough gives you more control. You can actually use a mix of the two.
Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com