>Hi Sergey,
>
>Thanks for the response. I am currently using SQL Server 7, sorry for not giving this information at my 1st post. What would be the method for SQL Server 7?
You can pass the key fields a comma delimited list a stored procedure, build SQL Select string in it and execute it using EXECUTE command or sp_executesql system sproc. Or you can build it in VFP and send to SQL Server.
--sb--