Relationships

[vgersghost]

Hello:

I have I believe a good normalized database, with good relationships, the question I have is when I open the relationship table it shows additional or duplicate relationships of the same tables. I delete these duplicates and then they return. This does not seem to effect performance. I have check queries to see if the relationships match, because I thought this was the cause.
Any ideas why this might happen and how to prevent from happening again.

Thank you

 

[ScottGem]

If you have aliases in the Relations window it probably means circular references. You might want to do a screen shot and attach it.

 

[vgersghost]

Thank you ScottGem

Attached pdf printout of the relationships. Any item with _1 is the duplicate that keeps reappearing. Please note, not all the tables are related. Tables are only related for each group of programs.

thx

 

[ScottGem]

Hmm, you do seem to have some circular references, but its not clear what's causing them.