I have searched tgrough forms and not sure if I found the answer or understood the logic. I have issue with relations ships beween tables.
I have 3 tables:
1) NAME OF SHOPS - 104 lines
2) AUDIT OF SHOPS - arround - 96 lines as not all shops audited
3) DETAILS OF SHOPS - arround 90 lines as not all shops have details
When I crete relationships between colums "NAME" of shops - there will be 90 lines, due to 14 shops are not mentioned. I want to see and indentify which 14 were not mentioned, therefore I I need to understanh how relations ships will not filter first source column from the table "NAME OF SHOPS"