Creating a new table that is a combo of two filtered tables
Forgive me, I don't think I have the terminology down yet..
What is the best practice when I want to create a table from "subsets" of other tables. For example, there are entries in table A that I filter out based on some criteria. I use the same criteria to find entries in table B. Now I want to create a table that consists of those filtered values.
The filter values from both A&B will have the same fields.
Thanks in advance!