Filemaker pro experts,

I've created a reasonably complex database but with very little knowledge of FMP11. I have a rudimentary background in programming but I have to admit it was a long time ago although bits are coming back quicker than I expected.

I have created a report that effectively produces a job sheet for employees. It works really well in find mode in the browser but I want to create a script to automatically save each individual employees work for the month to a predetermined location.

Rather than bombard you with loads of code, I've explained in simple terms what I've done.

TABLE A - Booking_items includes two critical fields:

bkit_date ( so this is the booking date )

Bkit_employee ( this is the person doing the job on that date )

In browser mode, I click find, type in the '*/3/2012' and 'Matt' in the employee field and click on perform find and sure enough all of the jobs for matt in the month of march appear. I then subsequently save the list as a PDF or Excel spreadsheet.

What I want to do is this:

-Set up a script that checks if all employees have work in a given period

-Then perform the above operation for each employee that has work

I just don't know how to do it. Do I use loops? do I use filters, perform finds? I'm completely lost and out of my depth. Any help would be greatly appreciated.

Many thanks

Matt

Do you also have an Employees table, related to the Bookings table?

No, would that make it easier?

Yes, because then you can find the employees that have bookings in March and loop among them to produce the March schedule for each in turn.