Thanks for your reply Lester.

I wasn't aware of the IB limitation.
I'll explain what I am doing so you can see why I am getting this
problem.

The user prepares a query on multiple tables which results in records
being displayed in a TIB_grid. The user can then select any or all
of the records to be included in a report. I then create a temporary
table to hold the selected records, open a query on the table and
pass it off to a report generator. Thus the temporary table can have
any number and type of columns and needs to be created each time.

This works perfectly except for the table in use problem (although I
now have a solution to this).

Obviously I will have to come up with another solution. Would your
blank table work in this situation?

Any help would be appreciated.

Regards
Bob

> Bare in mind that making structural changes to the database
> do require you to Backup and Restore after ( I think ) 256
> changes. This is a 'problem' that could cause your method to
> become a pain.
>
> I have a 'blank' table into which I pump the data, and then
> just change the SQL to give me the view I want for the
> report and Tee chart. It works well without the structural
> change.
>
> --
> Lester Caine
> -----------------------------
> L.S.Caine Electronic Services