Referencing columns in one table to more than 1 table

Hi, I’m new to appsheet. Is it possible to reference the columns of 1 table to more than 1 table?

My basic structure is Table A (list of volunteers), Table B (list of beneficiaries).
Table C (Planning Table) will draw names from Table A to reach out to names in Table B. I would like to create Table D which provides multiple status reports on the progress of Table C.

How can i draw information from Table A and B which are subjected to the conditions placed in Table C?

1 Like