I have made a ACCOUNT system. In it I have in Main Menu Window or Menu Main Items like FORM, REPORTS, UTILITY and so on. And in these
and i also others Forms like in FORMS:
* ACCOUNT HEADS FILE
* PAYMENT VOUCHERS
* RECEIPT VOUCHERS
* JOURNAL VOUCHERS and so on
and i made them differents tables depends on my needs and as well i made a table named PASSUSR for users passwords stored in it.
My QUESTION IS:
* How / What should be the structure of this PASSUSR table as i want
to save USERID, PASSWD in it and RIGHTS of different uesrs like
there is 3 users one for MANAGER and second for Assistant of Manager
and third for Operator.
Manager can do all the things where as Assistant can do little and
Operator can do only Data Entery. as i can change there rights of
using of Forms + Report + Utility by changing columns value of PASSUSR.
HOW CAN I ACHIEVE THIS... ???
ANY BETTER SUGESTION PLZ... thanks in advance...