Dynamics NAV Drilldown when Filtering on Data from Another Table
When performing cross-table filtering [i.e., when using LINK= for NL("Filter") ], there are situations when you will not be able to drill down on the cell.
This is due to the fact that Dynamics NAV will not accept a list as a filter, so Jet attempts to create a set of filters that will uniquely select the exact same records. This is possible when there are only a few records being returned. However, if there are too many records, drilldown will not be possible.