I have a search screen that builds a temporary table which is displayed in a grid format in the screen that is called after the search screen. I would like to create a new table every time the user does a new search. If I don't create a new table, the following conflict occurs. If one user does a search the table holds the results of that search, then a second user does a search the table has the results of both searches. Is there a way to avoid this problem using only one table?

The only solution I've come up is to create a new table with an incrementing variable that held in another table. For example, I have a table called holdres. I copy the structure of this table to a table with the variable cttable attached on the end. I'd store the string 'holdres' + alltrim(cttable) to a variable called holdcttable. THe actual name of the table would be holdres1. I would deference holdcttable as &holdcttable. Is there a way to store information in this table. I'd tried the syntax &holdcctable.id. FoxPro 5.0 said it could not find the variable holdres1id. It did not seperate holdres from id. Is there syntax you can use when storing data to a dereferenced table name? Also, can you assign a grid to a dereferenced table if it has the same structure that you created with the original table, in this case holdres.