i m creating a int report.
i have 1 int table in which records r like D001,D002,D003,D004 etc.
i have to create 1 more table with 2 fields like successor & predesor and this should be related to first table. the req o/p should be
successor predesor
D002 D001
D003 D002
..........................
means first data should be in predesor after read successfully then only second data come in successor
what is the logic to relate these two fields and get req o/p