Forum Discussion
Problems with four-table relationship
Hello! I'm having trouble doing something that I thought would be simple. I can't show the column and table names, but this is the model of the relationship of my tables: I have two tables (b...
You say the red table is a category table. This would appear to be a dimension table based on your description. So why do you have bidirectional many to many relationships between this table and the others? If it is a dim table, it should have unique values for ID and Categories.
Hello, MattAllington
This can happen because the same ID can have more than one different category and a category can have more than one ID as well. The blue and yellow tables have rows that repeat several times.
So I wanted that, when filtering a specific category in the dashboard, the chat line shows a line for each ID that this category has.
