Have you considered schema prompting? I had 7 identical schemas so I placed a prompt in the ‘Owner’ portion of the table name dialog box. When a user selects an object and hits ‘Run Query’, the schema prompt asks the user which schema to use…in a user friendly way of course. Check out this thread if you’re interested…
Cindy Clayton 
(BOB member since 2002-06-11)