Hi all
I am working on the database bit like of auditing.
The database is simple only thing is the permissions to various
users.In the database the audit report(memo field) is issued to each
authorised person(AP) of department and he has to comment(memo) on that
and
perform action(memo).

It is required that when user or AP open the form he is only able to
see his
department audit report details.(bit kind of filtering the data for
that particular
person).It is also required that AP of one department is not able to
view
information of other department.

I am bit confused to do it as there are 10-15 departments.
Is it the normal user permissions that can work or I have to do in
different way.


There is no worry of design security or like that.
I hope I make it clear..
Thanks
anil