Searching for related records

[BlackWolf]

I am new to FileMaker, but I have had experience with other databases. I am having trouble figuring out how to do a specific search.

I have three files. One is called "Jobs" which keeps information on the jobs our department is working on. The other is called "Assignments" which keeps an Employee ID and a Job Number. The last one is called "Employees" that has the info on employees. I already have a relationship that links the Job Numbers from "Jobs" and "Assignments" and on one layout I have a portal that shows all the employees assigned to the job.

What I want is to make a layout that will show the jobs that each employee is working on, so each week the boss can print out a report with someone's name on it and the status of all the jobs they are working on (which shows info from the "Jobs" file).

Thanks for at least taking the time to read about my plight.

[LaRetta]

Hi BlackWolf,

You should always produce reports in whatever db is the primary reason - in this instance, your Employee db. Create a relationship from Employee to Assignments on EmployeeID.

Design your report and create a script. Place EmployeeName in sub-summary and sort by this field. Place job information (from your jobs db) in the body. This script can then be called as an external script if you wish.

LaRetta

[BlackWolf]

Thanks LaRetta!

I had tried something similar without much success, but I took your advice and it is working now. I had to add a few calculation fields to the Assignments file, but it is working this time!

Thanks again.