Hi, I am relatively new to Filemaker. I am trying to use the TimeCards template to do timecards for my company's staff.

When we choose the week and have the staff enter their hours, everything seems to work fine, but when we switch to a new week, to enter hours for the next week, the hours just stay there. Is there a way to keep the staffs hours from multiple weeks in one database? Or is filemaker (or maybe just this template specifically) just not geared toward this sort of thing?

I think I understand why it doesn't work, the repeating fields don't seem to have any relationship with the date selected, but is there any way to fix this to make it a functioning timecard? Or would we have to just use a separate database for each week?

Here is the file with the staff hours we've filled out so far, if you would like to take a look:

http://amchap06.googlepages.com/JAMBOXSTAFF.fp7

Thanks for the help.

You have touched upon one of the main problems with the example files that came with your application, i.e. they use Repeating fields, instead of a relationships.

Do an Advance Search for Timesheet, and you will find some more information about this.

Lee

Take a look at this post. It got pretty extensive and may be of help.

http://fmforums.com/forum/showtopic.php?tid/196814/post/297482/fromactivity/myposts/#297482