I need to consolidate info from 3 small tables (actually, cursors) into one, column by column. I would appreciate any suggestions as to a method, particularly as to keeping track of the record pointers during the process.

Each small cursor has two fields, but any number of records. I want to copy all the records from table 1 into fields 1 and 2 of the large table, then copy all records from table 2 into fields 3 and 4 of the large table, and finally copy all the records from table 3 into fields 5 and 6 of the large table.

I am expecting to use SCATTER TO array and GATHER to fieldnames to move the data. The problem I have is figuring out how to ensure tracking between the record numbers of each small table and the large table.

I would appreciate any suggestions.

Thanks,
Neil Preston