How to determine a row id number to each row of a filtered data master?

Mario shared this problem 16 months ago
Not a Problem

It is quite simple to associate a field id autoincrement to each record of a table (in a table of n records), but when I have to restrict the result set to k occurrences of the n, I would have a field or a way to show sorted id numbers, from 1 to k . How can I do that?

Comments (1)


Dear Mario,

The following example should help. Kindly let me know how it goes.