security filter applied to specified item per user but error display when another user add another item

Hi guys i have one problem i make security filter to one user to see specified item

ex

I create user A to see item Sp in purchase order

I succeed to make this but the problem is

when another user add purchase order with another item category as item WA

it make problem to user A when he open in next time(because item category for last order not match value for security filter for user A)

why?

can i prevent this

are any one have solving to proplem please help me

Kindly explain in more detail

what details you need

I will explain proplem from first

I have two useres

A

B

AND two itemes sp,wa

I need to assign role to user A to see item sp but not see wa(spare)

I need to assign role to user B to see item wa but not see sp(water)

if i make purchase order have sp item this is last record i added and his item category sp then user A can see order i make because last record added sp so user A

Can open purchase order form and browsing orderes

But proplem happen when user B open purchase order form . the purchase order form not open and give him error “you dont have permission to read item table”

because last record have sp item category code. how i solve this proplem

user A

have two roles

ALL

spare

ALL(have as following)

all table data one by one(without item table)

read insert modify execute

tabel 0 yes yes yes yes

form 0 yes yes yes yes

report 0 yes yes yes yes

spare role (have as following)

item yes yes yes yes item category code=sp

User B Have two roles

ALL

WATER

ALL(as following)

all table data one by one(without item table)

read insert modify execute

tabel 0 yes yes yes yes

form 0 yes yes yes yes

report 0 yes yes yes yes

WATER(have as following)

item yes yes yes yes item category code=wa

how i solve this proplem(how to avoid last record not much security filter not affect to form of purchase order)

i need solve to proplem if possible

Set filter on OnOpen form to see orders which are created by same users…

Like user A can see only orders created by A only…

User B can see orders created by B only…

for this you have to padd USERID on creating of Order

OK good but i need to make indirect access to item table can you tell me how this found in this article http://www.navision-girl.com/2007/02/security-filter-record-level-security.html in point number 3