Selecting Unique Records from a table

I want to Select only unique records from a table.
Waht are the ways to do it.
And What is the best way to do it.

  • Hi Ritesh,

    Are you sure you posted in right forum as I know Navision opened its office recently in India and you have posted in XAL Forum which is an old version?

    If You are using Navision Financials/Attain then:
    1. Records sorted on a Key(Primary Key,Any Secondary key defined/you may define to maintain uniqueness of data)
    2. Thru' Filters(Field/Table)
    3. If you are talking of selecting particular records only then you can use Edit-->Toggle Mark(Ctrl+F1) to select individual records and then View-->Marked only option to view all selected records.