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