Why does my form create duplicate records?

  • Thread starter Thread starter Tony Williams
  • Start date Start date
T

Tony Williams

I have a form that is based on a query. When I edit a record a new duplicate
record is created. Why is this happening? The query is set to Dynaset
(Inconsistent Updates)
TIA
Tony
 
Hi Tony,

I'm not an expert so my answer may not be as complete or succinct as it might
otherwise be.

This happens to me when I have a table in a query where there is more than
one record linked to the main table. e.g. if there are two addresses for one
customer and I use the address table in a query with the invoice table I
might get two invocie records instead of one. The way I get around it is by
making one of the addresses a "Main" address and filtering for that in the
query.

Like I said though, I am not an expert and there may be simpler ways of doing
it.

Cheers,

Aran K
 
Back
Top