I have a Table with some 100.000 records.
The two main fields are the NAME of the individual, and the DATE (creation date), both fields are not unique, i.e. every individual may have many records added with a different DATE.
In each record of each individual I need to have a field (let's call it "NEXTRECORD") representing the Record Number (or RecordId) of the following record of the same individual (by DATE).
I guesses should be simple but I am stuck on that.
Any help ?