Grateful for some advice:
My problem or thought process is the following:- (using MS A03)
I have a simple database . One table has a number of fields.
Groups of records have the same value for a particular field...In other words
record1, field x has value A
record2, field x has value A
record3, field x has value A
record4, field x has value B
record5, field x has value C
Several users have access to this database but each user can/should only see records of a particular value for field x...in other words
User Bob should only see the records of field x with value A
User Tom should only see the records of field x with value B
My idea is to create a login form based on a username and password which would be looked up in a separate table. Once the username and password is verified, the process/routine would then only allow access to the records he/she is entitled to view and/or amend.
Is this feasible and /or is there a better way of addressing this problem?
Thanks (I am willing to go into more detail)