Forum Discussion
Issues Creating a Relationship
thank you CahabaData. I will search this, but my ultimate goal is to use week from my main WEEK table as a slicer to be able to filter my views that would include fields from multiple tables.
For example, when my slicer is selecting week 1, it will show data below for WEEK 1 only
WEEK | ANNOUNCEMENT | FACULTY SCORE
from week table | from announcement table | from faculty table
joined to week table joined to week table
I hope this makes sense.
okay, now I can do what you seek in a simple trial; 2 separate tables each with a year column and then a stand alone Year table. I join the Year table to the 2 tables and a single slicer using the Year table works on them both.
but these 2 tables join nothing else; and I see from your error message it is referring to a join to another table..... It is not clear whether there is perhaps a date field in that problem join also? in some way..... while you could probably delete this problem join just to test the slicer functionality I imagine that causes other problems.....