• It may be, but I think the problem is scrolling throgh the resultset one at a time.

    We get a company from the initial resultset, query the GL20000 table and insert rows, then query the GL30000 table and insert rows and then go to the next company.

    This may be the right way, but it just seems that we shouldn't have to go one row at a time.

    Tony

    Things will work out.  Get back up, change some parameters and recode.