my database covers 7 areas of manufacture, sales, engineering , purchasing, stores, quality , finance
each person can log onto their own area with a password
the backend is split away from the FE .
there are about 60 tables, 100 forms, 120 quires , 20 reports of which i am trying to tide up a bit . say 10 % of each will/could be removed
my question is
is it beneficial for me to create a FE for each of them areas instead of one so there is less tables, forms etc in each and why
thanks steve
each person can log onto their own area with a password
the backend is split away from the FE .
there are about 60 tables, 100 forms, 120 quires , 20 reports of which i am trying to tide up a bit . say 10 % of each will/could be removed
my question is
is it beneficial for me to create a FE for each of them areas instead of one so there is less tables, forms etc in each and why
thanks steve