Hi!
I ran into a problem related to tables' relations within a query. When I have a "cycle" where relations keep going from table to table and end up within the same table they started from, that will be a problem. Example below:
When I have a query (as above) that will provide me with PersonName, AlbumTitle, ProductionDate and SongName, I get an empty result, but when I select and "delete" the relation between Album and Person table (picture example), I get valid results.
My confusion is why does the second query without the relation work while the first one doesn't? I mean, when I "delete" the relation, it actually remains there in the background, doesn't it? If yes, why is it important to have to remove it from Query Design if it still remains there?
I ran into a problem related to tables' relations within a query. When I have a "cycle" where relations keep going from table to table and end up within the same table they started from, that will be a problem. Example below:
When I have a query (as above) that will provide me with PersonName, AlbumTitle, ProductionDate and SongName, I get an empty result, but when I select and "delete" the relation between Album and Person table (picture example), I get valid results.
My confusion is why does the second query without the relation work while the first one doesn't? I mean, when I "delete" the relation, it actually remains there in the background, doesn't it? If yes, why is it important to have to remove it from Query Design if it still remains there?