before I take the dive.

I need to update a SQL 7 database with the same information from a FoxPro form that updates a FoxPro database. Look at it as a replication effort.

My strategy is to use SQL passthru to open up a connection, and add a record to the SQL database behind the scenes, so the user is not aware of this extra update.

The question I have is what do I do in the case of an update? It's not like I can SEEK and REPLACE here. Any ideas?

DP