James-

If you really need to get at the already open table, you could have a open table registry in your application object where tables are registered as opened when they are opened. But, AUSED is very much the way I would do what you are talking about.

I can think of one contingency you might want to consider: if you are using views, the base tables for views will also be in the AUSED array. Whether that affects your design or not, I don't know.

>So I can search for a table that might be already open under another alias. If there is a quicker way to do this besides looping through all the used workareas, I would certainly like to know it.