hi there!!!
I work in a firm where our program is dependant on the financial year. So, our tables are also stored in folders named
after the ongoing financial year i.e., 2000-2001,2001-2002 etc. After the end of the last year, we had to carry over to
the new year where all tables in the new folder were zapped. Now, a situation has arisen where I require some of my
programs to take data from the current folder(2001-2002) as well as the previous folder(2000-2001). But the tables
have the same name in both the folders. How do I accomplish this objective?
Also, the tables in the current folder have already been fed with new data. So, I cannot just copy previous folder's
tables in this folder. I tried appending records from old table into the new table but did not know how to 'use' and
'select' tables in the 'do while-enddo' loop.
Please help me.
Thanx.
Ram.