Users Security

[Bakr Z via AccessMonster.com]

Hi...
I have a database for customers...each customers contact with a salesman...
each salesman has more than one customers. He can access the database and
update or modify the records that are related to him.
I want to make an accessbility limitation that each salesman can access only
his related records(where salesman field is his name)...
Is there any capability to handle this issue in this area?

 

[Keith]

Hi...
I have a database for customers...each customers contact with a
salesman...
each salesman has more than one customers. He can access the database and
update or modify the records that are related to him.
I want to make an accessbility limitation that each salesman can access
only
his related records(where salesman field is his name)...
Is there any capability to handle this issue in this area?

See my reply to Matt L's question.

Regards,
Keith.