Subject Switching between views?
my program will be used by two distinct user groups. They will
share the same tables, but their data will be seperate, perhaps by
use of a DEPT CHAR(3) column in each shared table. I know I can use
Views to allow each group to access their own data only, but I'm not
sure how my program can dynamically switch between views in all my
TIB_Query SELECT statements etc, according to which group the current
user is from.

Can anyone tell me if it is possible?
(BCB5 / IBO 3.6Cf / Firebird / Win95)