Morning all! I am building a db in 2010 which will be used for HR evaluations. It currently has a user login which in the background designates that user's security level (i.e. admin, director, supervisor, etc). The login script works perfectly. The main menu works perfectly.
My main issue at this point is developing code to make sure that the specific user logged in can only access their own records. For example, this database is for the fire department. The fire department has battalion chiefs and captains. Battalion chiefs work specific shifts and stations. If the day shift battalion chief logs into the db, he should have acces to ONLY the staff on his shift and his station. I do have shift and station fields within the employee information tbl so the information is available. I just have no clue where to put the code (under the OK button of the login screen?). What commands should I use?