Table populated by other tables


#1

Say I have Table A which is the backlog of tasks for Team A, and I have Table B which is the backlog of tasks for Team B.

Is it possible to have an auto-populating Summary Table which is populated by combining Table A with Table B?

thanks.


#2

I would have a Tasks table and a Teams table, relating each other with a Linked Record field. You could create Views on the Tasks table to filter tasks for each Team, and of course any View for summary or whatever you want.