Oh boy... not sure if this should be in find or calc section: Payroll question

[place]

I'm a DIY.... unfortunately.   

 

I feel like I am missing a puzzle piece of knowledge and am hoping someone can point me in the right direction to research my answer.  both tables are childs 

 

 

Table: Payroll time sheets- people log on and submit one record for the monthly time sheet.   It has a total of 25 entry dates, to put in their time.  

 

 

Table: time off- people submit requests for leave, one record for each day off. 

 

 

What I want to do:  when they fill out the timesheet, I want those fields to zero out if they have taken that day off.

 

What I have done that does not work:

 

 If (Absent::date ≠ ${1date} ; 20; If (Absent::SS ≠ ss; 1; If (Absent::session ≠ "AM"; 2; 0)))   it only looks at the first record, not all records.

 

Also trying to set up a find, but could not enter in matching the contents of another field

 

 

What direction should I go in?  Just give me a direction to look up, please!

[comment]

Instead of 25 fields, you should give your users a portal to enter their work dates as individual records in a related table (same as they do with the requested days off). Then you can relate the two tables matching on date - and decide what to do if there is a matching record.

 

 

---

BTW, when Filemaker warns you that a field name is illegal, it is best to heed the warning and avoid the ${1date} notation.

[place]

Thank you for the suggestion and good solution. Unfortunately at this point they have to be related to the parent. I have thought about doing a triggered find per date field, but need to figure a way to do it.

Any other directions?

[comment]

Unfortunately at this point they have to be related to the parent.

 

I am not sure what exactly you mean by that. Who are "they" and what is the "parent"?

[David Jondreau]

comment's got you on the right track.

 

One tip: Don't start your field names with a numeral.