In the system administration menu you can setup record level security. In this form you select the table InventTable and choose the applicable user group. Then you can specify the query which items they are allowed to see.

You can do this based on item numbers or better a property on the item where you specify this item is no longer used. Or maybe the query excludes some item groups.

NOTE: If the user has multiple roles where they have access to the InventTable. All roles must be setup with the record level security.

In the past I once removed the table from the user groups. Then on one or mulltiple user groups I only gave access to the Table and so I could manage easily the record level security for multiple users.

Thanks for your help Andre, sorry to have waited this long to answer. I did exactly what you told me, but the group of article I chose to make invisible is still there. Everybody can see it even the group of people I put a restriction on. I join the images to show you how I did it, I hope someone will be able to find me a solution.

I've try to add a screen shot but it doesn't seem to work. Anyway, despite the fact that I created a query concerning an item group we call "Lub03" and I made that restriction on a user group called "Adminxxx" a user who is only part of the group Adminxxx can still see these articles. Maybe there is something wrong that I have done but I don't know what.

In the system administration menu you can setup record level security. In this form you select the table InventTable and choose the applicable user group. Then you can specify the query which items they are allowed to see.

You can do this based on item numbers or better a property on the item where you specify this item is no longer used. Or maybe the query excludes some item groups.

NOTE: If the user has multiple roles where they have access to the InventTable. All roles must be setup with the record level security.

In the past I once removed the table from the user groups. Then on one or mulltiple user groups I only gave access to the Table and so I could manage easily the record level security for multiple users.