Duplicate records appearing in continuous form search output--causes?

[WesHarding]

Hi all,



I have a search form that outputs records from a query onto a continuous form. The query itself sources three tables. My issue is I in some cases am getting repetitive records appear. For instance, I search a farmers name, and their record is appearing twice. When I look in the query it is also appearing twice. I am sure I do not have duplicate data in my tables, so this has me a little stumped.

Any ideas of comment would be happily embraced!

Sincerely,

Wesley

[RuralGuy]

Are you using Joins in your query?

[WesHarding]

Yes! I experimented with my outer joins. Doesn't look like they are causing the issue

[RuralGuy]

Experiment with the query (which is then cause of the duplicates). Cut down the tables until you find which join is the culprit.

[WesHarding]

Excellent idea, I will report back if it works!

[WesHarding]

I have found the answer!

I have two, one-to-may relationships connecting to a single table in this query. Upon removal of one of the tables I have zero repetition! I'm not exactly sure why this occurred (i would love the explanation) but I am very thankful it was a simple fix!

[RuralGuy]

Excellent! Thanks for posting back with your discovery.