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