Filter question - similar to SQL in clausule?

Hi All ,

NAV 5.0 SP1

I need to amend the Sales line “No.” lookup so by default it only shows the items that are related to the customer.

Rule is that if the Item is in the pricelist for the customer than it should show up .

Question , how do i build a lookup using the Item List form ?

I assume one solution would be to build a lookup form based on the Sales Price lists table, but I would like to save on that work .

In sql I would to sth like this :

Select * from item where No. in (select * from Sales Price lists where Sales code = xxx)

Any ideas?



After all I created a new field on the item with concatenating all pricelist into one ,so a filter can be put on .