troubleshooting Question

Pinpoint the correct data via relationship

Avatar of sam_thwaites
sam_thwaites asked on
FileMaker Pro
1 Comment1 Solution278 ViewsLast Modified:
Hi Experts,

Info:
I have table with salary & allowance history [Allowance History]
This table is linked to a calculations table (insurance and tax) [Calculation Table]
The relationship is:
   - [Allowance History] employee_id = employee_id [Calculation Table]
   - [Allowance History] date_created >= date_start  [Calculation Table]
   - [Allowance History] date_created <= date_end [Calculation Table]

Problem is
When I set the period dates (date_start and date_end) and employee id in the Calculation Table
it gets the data from the Allowance Table.....However, if there has been more that one modification to the salaries/allowances within a period, the relationship always gets the first data from the period instead of the last.

Example:

Allowance History Table Data
Employee ID      Date                    Amount
001                    12-March            $5000
001                    15-March            $6000
001                    17-March            $6500


1. I set the period in the Calculation Table to "March" and Employee ID to 001
2. I except to get the result of $6500 to do the insurance and tax calculation
3. Actual result is the first data in the period $5000

Question
How do I get the relationship to get the last update within the period?

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 1 Comment.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros