bedollandres
Posts: 48
|
Posted: 04/15/2005, 2:44 PM |
|
I'm using CC 2, with MSSQL, ASP 2.0 and templates.
I have a list of proyects. These proyects can belong to 4 departments.
When the person in charge of department 2, logs in, I want him to see the proyects of his department.
one table defines the users:
userid, name, id_department
another table defines the departments
id_department, name, location
another table has the proyects
id_proyect, name, ..., id_department
any help is appreciated.
_________________
bedollandres |
|
|
Nicole
Posts: 586
|
Posted: 04/16/2005, 12:34 AM |
|
Hello,
You can create a view in your database that joins all three tables and outputs department name and project data. Use this view as a source for a form and to filter it for logged in user ID add Input parameter of Session type.
_________________
Regards,
Nicole |
|
|
bedollandres
Posts: 48
|
Posted: 04/18/2005, 7:01 AM |
|
Thanks... but I forgot to mention this... the leaders of each department do not have any projects assigned to them... only the rest of the users that belong to each department have projects assigned...
So when the leader logs in I need to lookup the department he belong too and go get the projects of his department, so if leader "3" logs in, he belongs to department "2", he sees a list of the projets that are assigned to department 2".
_________________
bedollandres |
|
|
|