>I am creating a program in which I create tables to preview reports. I delete the temporary tables after the report is done being viewed/printed. The program is a multi-user program and if it so happens that User A is previewing the report and User B wants to view the same report they would get an error because it tries to create a table with the same name.
>
>I have thought of two options. One would be creating a different name for the table everytime it's created (based on a datetime stamp or something), but the question is how do I refer to it in my create table command?
>
>create table (blah);
>
>The second option is just to lock the table and use some sort of wait window for User B until the program is done, but this is less desirable as the first option.
>
>Any help is greatly appreciated.

Take a look at the SYS(2015) function:

LOCAL lcTable
lcTable = SYS(2015)

CREATE TABLE (lcTable) ...

do some stuff...

* Cleanup:
ERASE (lcTable + ".DBF")