Table relations problems

[percarlen]

Hi,

I've spent countless hours trying to solve this and I would greatly appreciate any help.

I'm using Appsheet's own database for my data and this is my problem:

Table A does not have any (outgoing) references to any other table.

Multiple rows in Table B can refer to the same row in Table A.

Multiple rows in Table B can refer to the same row in Table C.

I'm now creating a view based on data in Table A. Appsheet automatically gives me the rows in Table B which are related to each row in Table A (pretty neat!). However, I also want to show the rows in Table C which are indirectly related to each row in Table A. I don't want to show the Row ID to the end user, I want to show the label value.

Table A

Row ID	Label

Table B

Row ID	Label	Table A reference	Table C reference

Table C

Row ID	Label

[Steve · Accepted solution]

Add a virtual column to Table A named (e.g.) Related Table Cs with an App formula of:

[Related Table Bs][Table C reference]

[percarlen]

Thanks, but that gives me the Row ID's, not the label values. At least in the view that tests the formula. Is that expected behaviour?

[Steve]

Yes, the test feature in Expression Assistant is going to display the column's actual value. Go ahead and put it in place and see what it does.

[percarlen]

Thanks for your help!