I have multiple tables for tracking different projects / workplans, and the columns are different in each. I created a field on each to note tasks/projects in each workplan that has to be reported to my leader ("REPORTUP", as a single select). I set up a list view in each table that will show only those items with a filter, but I would like to have a table that would pull the "task" field from each table when I select "YES" on the "ReportUp" field. I have not been successful using the "linked field" set ups. When I did it, all of the tasks were in one box in the "consolidation table". I essentially want a stacked view. Is that possible?
