>>>>Jim,

I don't have any buffering set, exclusive is on, private
data session, and one correction on previous messages, when
user deletes one record, the database still has one record
showing. No I have not checked indexes, there is one set
to the custname and seems to work fine. I am using a table
directly. It's a free table if that makes a difference.

One other thing, the record is scattered from a different
database file and inserted into invoices, I don't know if
that has anything to do with this or not. Should I set
up a relation between the two databases? Would it help?

>After the addition of the record, the user uses
>>a browse screen to look up record and it show two records.
>>
>>Becky
>>
>>>Jim
>>>>
>>>>INSERT INTO INVOICES FROM MEMVAR
>>>> REPLACE invoices.date WITH DATE() NEXT 1
>>>>
>>>>this is it, but it creates two records, I am wondering
>>>>if what it is really doing is writing over the first
>>>>record in the database and creating one new record.
>>>>
>>>>Interestingly, the user reports that when he tries to
>>>>delete duplicate record, both records disappear.
>>>>
>>>>Any thoughts? I running out of things to try.
>>>Becky,
>>>
>>>How is the user determining that there are two records? Is it a browse with two lines in it or is it a count that shows two more records than before?
>Becky,
>
>Ok, there are a number of variuables here, are you using any buffering? Is this an updatabale view or are you using the table directly? Is the table indexed with and order set? Have you checked by reindexing the table to be sure there is no bad index problem?