I have two departments that report to me that I must track in my scheduling database. My schedule is viewed in a Portal. Occasionally I need to view only the jobs in one specific department. I have a script which identifies each department with a hidden text field. I am trying to perform a find (via script) so that I can view a specific department within the portal and I am still getting all records. It sounds simple, I think im missing something thats right in front of me

Describe the relationship between the table the layout is based upon and the data shown in the portal you are trying to find a bit more.