QUESTION: Tables with the same name for different users?

Apologies if this is a FAQ, but I've got a question for all of you gurus: Q1: Is it possible to have two tables in the same database with the same table name and have different users pointing to one or the other? Q2: How can a 4GL application run unchanged in this environment without getting confused? Up until now, we have been using an Informix database under UNIX which resides in a single directory. We would like to be able to have multiple users access most of this database, but have their own version of a few tables. We do not want to simply merge the data into one table because this would mandate too many code changes. For example, User A and User B share the data in the product master table, but they have their own customer tables. Whenever the application code says something like, "select * from product_master", the shared product master table is read. Whenever it says, "select * from customer", the corresponding customer table is read for that user. Thanks for any help you can provide. - Jon -- ---------------------------------------------------------------------------- Jon Pardue "The plural of 'spouse' is 'SPICE'." pardue@rainbow.ecn.purdue.edu - Charlie Gordon "Old musicians never die, they just go from bar to bar." - Anonymous