I have an Access database and I need to restrict record access to records based upon the user and supervisor. I have a "Code" field that will identify the record user and also first and second level supervisors.(or group and subgroup) For example: The code XXX1A1 is a user and created the record. Supervisors XXX1A and XXX1 would also need to access the record but no one else.
Code would certainly help.