>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:
use (lcTable) alias MyTable
...
select MyTable
replace ... in MyTable
Grid.RecordSource = "MyTable"
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)