Forum Discussion
Filter multiple tables based on Status not working
Hello, i have the following case. A table with 2 columns ID / Status has to filter 10 tables. i would like to filter by status (1 = Active, 0=Inactive) All those tables reffer to an empl...
Does the 10 table include HR table?
HR is connected to all tables since i need to get the employee Names
It seem as the HR table and Employee Tables are interconnected, so Status is connected with other tables with an inactive relationship. By default , inactive relationship is not active and thus will not pass the filtering. So comes the issue you have.
Inactive relationship could be temporally activated with USERELATIONSHIP, but considering the number of your tables, that would be a long code.
Let's see what good proposals others may come up with.