How to use DISTINCT(as in MSSQL) in NAV??

Hi All,

I want to show some distinct reord in NAV Form, please let me know the way of same.

e.g.
Table Contain - Item Code & MRP
1001 200
1001 200
1001 300

On filter of Item 1001 the output required.
1001 200
1001 300

please help

Jai