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