Hello,
I am in a tricky situation and wondering if anyone can help me.
We have section access implemented where data reduction is happening across 20+ tables.
For one of the tables, let's call them Cars table.
This Cars table contains all possible cars available.
We have another table (Cars Sold) where we record which car has been sold.
The association between Cars and Cars Sold table is CarID.
When we associate the two tables, naturally data reduction happens and users only see records from the Cars table for cars that have been sold.
However what they want is the ability to see ALL the cars.
So we need it to associate both ways, if something related to cars sold is selected, only show related items from the Cars table. And if something from Cars table is selected, show the associative Cars Sold data.
How is something like this possible?
I know something can be done using set analysis but the problem is our analysis will not be at chart level, it could be anything from the data model.
Perhaps a dummy value is required in the Cars Sold table but I am having a really hard time trying to figure this out or even know if something like this is possible.
