>The table name is different for different users. This is a stand alone app that has many users who may have several incidents to work on. Each incident has a table. Each table will have a unique incident name.

This still doesn't hinder you to use the same alias for different tables.

The RecordSource for the Grid, SELECT commands, and IN clauses, among others, all make reference to an alias, NOT to a table. The alias is very often the same as the table name, but you can assign any other alias.

For example:

* (get input from user)
* (store this input into variable lcTable)
* (and then:
use (lcTable) alias MyTable
...
select MyTable
replace ... in MyTable
Grid.RecordSource = "MyTable"