You're welcome. I use this solution myself very often.
>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?
