Hi Tamar,
One thing I think might be useful is how to create a view when a SQL table has too many fields for VFP to read. I have found using an SP works well like: SQLEXEC(dsn,[exec sp_columns 'incident_name'],'c_columns'). Another route to take is to pull the data via sqltables() and sqlcolumns().
John Harvey
Shelbynet.com
"I'm addicted to placebos. I could quit, but it wouldn't matter." Stephen Wright