>>> Q2: How can a 4GL application run unchanged in this environment without
>>> getting confused?
>>>
>>> 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
try "select * from $customer" and set the customer variable to a different
table name depending on the user.