Forum Discussion
issue with relationships between 3 tables
Hi Puero1
With the relationship you created, you can select correct values from Table A and Table B or Table C and Table B to the “table” chart, but when you add values from the other table, it returns an error like “it can’t determine the relationship between two or more fields”.
For example, for 1 from Table A, it can relate 1 or 2 from Table B, since 1 from Table B can also relate 1 or 2 from Table C, so for 1 from Table A, it can’t determine whether 1 or 2 from Table C should be refer to
Table A Table B Table C
1 1 1,2
1 2 1,2
To get which you want as shown in the picture,
You can create a new table with the formula
Table = CROSSJOIN(TableA,TableB,TableC)
Best Regards
Maggie
Community SupportHi Puero1
Does "ID A" in Table A and "ID B" in Table B has distinct value and they can match each other? How does Table A <-> B look, could you show example data structure?
Best Regards
Maggie
Hi Maggie,
thanks for your reply. Yes they have distinct values and can match each other.
I made a screenshot with all values from all tables. These few values are enough for me to reproduce the error message.
Best Regards
André- v-juanli-msft
Hi Puero1
With the relationship you created, you can select correct values from Table A and Table B or Table C and Table B to the “table” chart, but when you add values from the other table, it returns an error like “it can’t determine the relationship between two or more fields”.
For example, for 1 from Table A, it can relate 1 or 2 from Table B, since 1 from Table B can also relate 1 or 2 from Table C, so for 1 from Table A, it can’t determine whether 1 or 2 from Table C should be refer to
Table A Table B Table C
1 1 1,2
1 2 1,2
To get which you want as shown in the picture,
You can create a new table with the formula
Table = CROSSJOIN(TableA,TableB,TableC)
Best Regards
Maggie
Hi v-juanli-msft,
thanks, now I understand the error. The CROSSJOIN works perfect for me. :smileyhappy:
Best Regards
André
