Hi all,

I've recently started developing in Filemaker 7, and am still
learning (Access and SQL background). One of my first tasks was to
redesign a simple To-Do List for multiple departments within the
company. It had been written with one table and one layout per
department. I decided to consolidate all tasks into one table and use
a department code as an attribute. I also set up a main menu to
navigate to each department, but I'm trying to use one layout for all
departments. Is this the correct way to do things? I've written a
script that sets a global field called "Current Department Code" when
the user clicks on a main menu department button. This allows me to
populate the department code field automatically when the user creates
a new record.
The problem I'm having is with a Find script. I switch to Find Mode,
and then perform a Constrain Found Set to filter out all the other
departments in case they turned up in the results. My Find Request is
as follows:

Tasks:epartment Code =Departments::CurrentDeptCode

CurrentDeptCode is the global field. However, this returns no records.
Is my syntax incorrect on the right-hand side? Any advice would be
appreciated for this newbie!

Regards,

John