I am designing a database for tracking payroll hours. The employess clock in and out creating a time card for each day they work. I'm not sure how to display only a specifc pay period with a beginning date and ending date other than using a find everytime I want to change the time period.

Is there a way to have a start date field and end date field that, when changed, automatically updates the found set? If not, is there a way to do this with a script (via a button)?

Any help would be appreciated!

If this is in FileMaker 7 you can check out using relational operators like "greater than" and "less than" to build portals that show all the time records between two dates. (If you need to have a found set instead of a portal you can simply Go To Related records from one of these date range relationships to build a found set.

In FileMaker 6 the same thing can be accomplished but it is more complicated. Let me know if you need more.

John