How do I define a filter on a N:M relationship?
14 January, 2015
Hi,
I have a N:M relationship between 2 entities (for example, EMPLOYEE and DEPARTMENT)
I want to define a view that lists employees. This is a basic [quote="select field1,field2,field3 from employee">[/quote] query
On this view a need a "department" filter, but this field is NOT on the view (because one employee can belong to many departments)
How can I achieve so?
Many thanks
Jordi
Hi Jordi,
sorry but I don't understand....why can't you just join the EMPLOYEE & DEPARTMENT tables in the view. Then the DeptID will be available in reports to be used as a filter to restrict which employees are displayed?
regards,
Dave
sorry but I don't understand....why can't you just join the EMPLOYEE & DEPARTMENT tables in the view. Then the DeptID will be available in reports to be used as a filter to restrict which employees are displayed?
regards,
Dave