changing find results on the fly

General support questions.
Posts: 1
Joined: Wed May 11, 2005 12:08 pm
PostPosted: Wed May 11, 2005 12:10 pm
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!
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Wed May 11, 2005 12:28 pm
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
John Sindelar
SeedCode

Return to General Support

Who is online

Users browsing this forum: No registered users and 3 guests

cron
(855) SEEDCODE
[email protected]
Follow us: