View Criteria question

Hi,

I need to create such criteria for my views so that people can only view their own department's data.

As an example:

u1 belongs to d1
u2 also belongs to d1
u3 belongs to d2

u1 creates records in various forms
u2 can view all these records
u3 cannot view these records

At best I do not want to store department information in each form. The logical route to get to the data might be so:

1. Get zoho.loginuser's department.
2. Get the department's users.
3. Show all records that have added_user as one of the department users.

I hope I have been able to explain my requirement. Any help will be greatly appreciated.

Harpal
Zoho Fan!