>Thanks! That helps a lot, but do I need to put in extra coding to tell VFP to look in SQL server table (how do I tell it to connect to the SQL server)?

There's a book 'Client-Server Applications w/h Visual FoxPro and SQL Server' at http://www.hentzenwerke.com/catalogavailability/csvfp.htm