I have two tables named (ITEMS) and (TRANS) , I need our app users to view only data which they enterd when they choose ITEM table , and I need when they choose TRANS tabel any user able to add and subtract the total count of any ITEM even if he is not the one who create the item .
It’s hard to understand what you are doing without proper context.
Is there any kind of relationship between the tables? What entity those tables represent? Which columns can be found in each one? Which columns you expect to change?