HELP - Duplicate Records

G

Guest

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)
 
G

Guest

If I'm reading this correctly, there are no duplicates. For example if an
employee with Track 1 is a member of Orgs 1 and 2, the following records will
return.

Track Org
1 1
1 2
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top