Duplicate Output

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report based on a query that shows a schedule for patients with some details about each appointment. For some reason lately some of the appointments have shown up twice. I thought that the appointments were entered twice (there is an index to avoid duplicate entries in the table) but that is not the case. They have the same Record ID but still show up twice. It seems to be happening more frequently. The query is generated programmatically from parameters that are set on my switchboard. There are two parameters, Language and Type of appointment.

Any ideas

Thank

Dan
 
Without having much information, I would look for the
structure of the query, Is there a possibe one-to-many
relationship where you thought that it was a one-to-one
and as the tables grow you may have increasing instances
where a one-to-many relationship appers to create
duplication.
Hope this helps.
Fons
-----Original Message-----
I have a report based on a query that shows a schedule
Click to expand...
for patients with some details about each appointment.
For some reason lately some of the appointments have shown
up twice. I thought that the appointments were entered
twice (there is an index to avoid duplicate entries in the
table) but that is not the case. They have the same
Record ID but still show up twice. It seems to be
happening more frequently. The query is generated
programmatically from parameters that are set on my
switchboard. There are two parameters, Language and Type
of appointment.
 
Back
Top