Duplicate Records - Can't Locate Source

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

Guest

(Posted also in Queries - but may be table relationships problm so postiing
here).

While working on a pre-existing database. Everything seemed to be working
fine until recently results are reflecting duplicate records.
Even my most basic queries return duplicate records which are directly
related to the # of sub-records related to the employee found in the ORG
Table. I've tried using SELECT DISTINCT, etc. but nothings helps.
Table RELATIONSHIPS appear to be fine and I've compared those relationships
to an older version (before changes).
If I have an EMPLOYEE associated with 2 ORGs, he prints twice, 3 ORGS, 3
times...

Example:
[Employee Table] (prim key field is TRACK)
(TRACK field here related) 1 ---> many (to TRACK field in)
[ORG table]
[ORG table] (prim key field OrgType)
(TEAM field here related) many ---> 1 (to TEAM field in)
[XYZTEAM table]
[XYZTEAM table] (prim key is SORT)
 
If I have an EMPLOYEE associated with 2 ORGs, he prints twice, 3 ORGS, 3
times...
Click to expand...

Sounds like you're basing your report on a query joining EMPLOYEES to ORGS.
That's exactly what you would expect - each employee record is repeated in
conjunction with each related ORG record.

What's the Recordsource of the report you're printing? Please post the SQL.

John W. Vinson [MVP]
 
Back
Top