Blue
White
Purple
Green
Red
Orange
Blue Light
White Light
Purple Light
Green Light
Red Light
Orange Light
If I have records with a value of Category=XXX how do I hide it from users with group names of User1 and GuestthanksL
Larry,create a custom view for your table.Modify its SQL query to hide certain records, grant permissions on this view to User1 and Guest and revoke those on original table.