>I have a scenario where I need to INSERT into a table, but only if the record does not already exist. If it does exist, then I want to UPDATE it. There are a couple key fields that I can use to do the matching. I have a table open in the current workarea, and some of the values from the current record are what get inserted/updated in the 2nd table that is open. What would be the best way to handle that?
>

Depends on your backend - with Oracle, you can use the Merge command. With a VFP backend, you can do something like

If Seek(...
    Replace fieldX With ... Next 1 In yourAlias
Else
    Insert Into ...
Endif

hth
-Stefan