I have used UPDATE so seldom. I had no idea it returned a _TALLY variable. This will work perfectly. Thanks!
>
>Update yourfile set x=Y where z
>if _tally=0
> Insert into yourfile ...
>endif
>
>>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?