I have created a Time Tracking DB for our Graphic Design firm. Basically it contains a Start and Stop time for each job. Each designer logs in, starts and stops the job and it's logged through a global time field. I then have a separate layout displaying all the time records on a portal from that designer (which lists every job done).

I now want to create a report where I enter the FROM & TO dates and the designers name so I can see and print all the records from that designer between those dates.

I am quite new to filemaker and my scripting knowledge is quite basic.

Any help to this problem would be much appreciated.

Thanks in advance.

Fabian

Presumably you are logging all the time slots in a separate table. You can then look at this table through a portal in different ways depending on the relationships between your tables.

e.g. If you connect your table of jobs to the time slot table, you can list the time slots for each job independently, in the same way if you link the table of designers to the time slot table, you can list the time slots for each designer. For this all to work the time slot table needs to store information to facilitate this linking - the job number to link to the jobs table, the designer (name or number) to link with the table of designers etc.

More complex relationships can also be made with combinations of these fields to build up dynamic tables - for instance you can show all the time slots for a particular designer for a specified job, by using a field that combines the job number and the designer.

Good luck and let us know how you progress - Anatole

Thanks Anatole for you quick response.

Basically I was looking to put two date range boxes on a layout titled TO and FROM. Then I would have a drop down list with the designer name on it. It would then show me a list of all the jobs that designer had done in a printable format from the date range specified. Maybe I need a script to do this. I am just not that familiar with the whole scripting thing.

I have attached the Time Tracker FM7 File in a ZIP format to show what way it works. Any help on this would be really great.

Thanks Again,

Best Regards,

Fabian

timetracker.fp7.zip