Two set of similar tables

Hello Everybody, I am quite new to Informix and the relational database system. I would like to know how can i solve this problem. A am developing an application that will interact with two sets of similar table interchangeably based on some values(may be using global variable) that set when logging in to the applicaton. For example if user no 1 use the application should update into A sets of tables, and if user 2, it should point to B sets of tables(but both with similar if not the same structure). I have created superview, but superview only points at one set of tables. What actually i am developing is a Client-Server application that will save information into a set of Temporary tables until a program is activated(by authorised users) where it will transfer the data into permanent set of similar tables(after some validation). Some of the users will have access only to temp. tables, whereas some users only to permanent tables but using the same application. Can this be done using superview? Your comments and advice highly valued. Syed. -- ---------- Signature ----------- Name: Syed Ibrahim Address: Sapura Advanced Systems Sdn. Bhd, 18th Floor, Menara Tun Razak, Jalan Raja Laut, 50350 Kuala Lumpur, Malaysia Tel: (03) 295-3472, (03) 294-3000 Fax: (03) 294-6587, (03) 293-3154