SET ORDER TO offset REINDEX GO BOTTOM endrec = RECNO() GO TOP DO WHILE
This is what I came up with... I need to create one cash offset record for each (as also in index 'offset'). The cash offset record must follow immediately after the group of transactions ('offset').
I thought about (as I started above) to REINDEX, then go to bottom, get record #, go back top, do while that, then after all done, REINDEX again to get those added 'offset' records that were APPENDed back in order after their kind. Am I making senses here? It's just what we have to do, for PeopleSoft, you know. Should I add records in another table, and then combine them together afterwards?