Forum Discussion
Relationships between tables null values
Good day,
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"
Thnaks
3 Replies
filter('name of shops',isempty(relatedtable('audit of shops')))
??
Thanks. "AUDOT of SHOPS" is a multy colunm table. The relation ships needs to be between NAME OF Shops column. I think RELATEDTABLE doesnt allow myltycolumn expression.
Is there workarround for this? Cannot figure out myself.
I;m thinking to experiment on Merging tables and replace "NULL" values with some other word (but that is my last option).
