filtering duplicate records in table

Hai all,

I need small guidens from all, i am navision 3.7 native data base.

In that One table contain multiple records . Other then primary key field remaing all fields contain some some duplicate data naturally.

But I wish to filter the requited(other then primary field) fields data unique.

for ex:- field1----a

field1----b

field1----a

field1----b

i need total output of field1–a,b.

please give solution for this problem.

Moved from the AX forum to NAV - Please try to post in the appropriate forum, it is the best chance you have of getting an answer!