Query joins and Table relationships

[Hisoka]

When I created a query, the program by default created a relationship between my two tables In Query DesignView,
But when I opened the relationships from Database Tools > Relationships, I did not actually find this relationship and it does not exist in the tables either.
When I delete this relationship from the query DesignView, the program duplicates the data.
Why does the relationship appear in queries? Is it called an actual relationship or is it just for creating the query according to the user’s request or something Else?

Thanks for any tips and guidance

 

[jdraw]

Here's a link to an article that deals with this topic -Relationships vs Joins (MSAccess).
I have seen other posts that provide a description/explanation, but that link conveys the concept.

 

[isladogs]

For additional information on this topic see

Relationships1

This article discusses the differences between query joins and table relationships and explains the important use of table relationships to enforce referential integrity. Three methods of adding relationships are discussed. The article also explains how Access uses the MSysRelationships system...

www.isladogs.co.uk