Only display records relevant to user
I have five different user groups (numbered 1-5) in dB column called MembershipType . Two of these user groups are Administrators (MembershipType= 1 & 5). Type 1 can view and update all user records, but Type 5 should only be able to view & update those with MembershipType=3&5.
The WADAusers recordset on the results page (set up using the DataAssist wizard) is currently:
SELECT UserID, UserEmail, UserPassword, UserFirstName, UserLastName, CompanyName, MembershipType, UserRegistrationDate
WHERE users.userVerified = 1
ORDER BY UserLastName ASC
This displays all the user records.
I already have a session variable for MembershipType set up. How would I amend the above Recordset so that Administrator user group 1 can view as normal, but Administrator user group 5 only sees MembershipType 3 & 5?