Calculation based on drop-down menu

[bwmccullough]

Hi everyone,

 

I'm new to Filemaker and I'm attempting to make a employee timesheet, based on a two-week payperiod.

 

What I've done so far is create a drop-down list for the start of the pay period. The end of the pay period is then calculated based on the start + 13. This works fine.

 

 

Currently I have a drop-down list for day of the week. What I would like to have is a conditional drop-down list for date based on the day of the week for the pay period. For example, day of the week = Tuesday, the date drop-down list would contain 17/06/2008 and 24/06/2008. I am trying to build this with a case statement, but I'm not sure if I'm on the right path or no.

 

Any advice you could give me would be greatly appreciated.

 

Thanks!