Forum Discussion

Frequent Visitor

9 years ago

Solved

Problem with table visual and relationship

Hello everyone! I am trying to create a table visual with multiple fields from one table , and one field from another table. I have created a relationship between these two tables by creating...

vanessafvg
9 years ago
maxlgv

try change the relationship to both (bi directional) rather than single for both tables

double click on teh relationship and when the box comes up change from single to both

Community Champion

9 years ago

try change the relationship to both (bi directional) rather than single for both tables

double click on teh relationship and when the box comes up change from single to both

maxlgv
Frequent Visitor
9 years ago
vanessafvgThanks a lot !!
Anonymous
Not applicable
8 years ago
Greetings,

I am having the same problem but making relationships cross filter direction as BOTH does not solve it, it is still unable to relate the fields of three tables in just one...

It is the same case, a main table in the middle, with two 1-* relationships. The middle table + values of one of the others works perfectly, but when I try to 'merge' all the tables in one visual, it shows the error.

Are there other ways to fix this problem?

Regards
- muneern
  Frequent Visitor
  8 years ago
  I am having the same issue -- except with 4 tables. I have set the filtering direction for all the table relationships to 'both.'
  
  My scenario:
  
  Table A
  Table AB -- which links Table A and Table B
  Table B
  Table BC -- which links Table B to Table C
  
  I can add fields from Table A, AB and B (or 3 tables in the other direction e.g. BC, B and AB), but as soon as I add a field from the 4th table I get the dreaded "Can't display the visual" error.
  
  Any suggestions?
- Anonymous
  Not applicable
  7 years ago
  Anonymous did u get solution for this?