I have a primary table, called demographics, that I want to use for filtering purposes..I then want to add three other tables. The problem is when I add a table the results for the remaining tables change. I have attempted left joins, but that does not cure the problem. If I take the smaller table out (fewer records), the problem goes away
One suggestion would be to use the demographics table as a separate data source and use actions to filter out the desired data.