>>>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?