Hello everybody!

My database has three calculation fields for 1) Years, 2) Months & 3) Days since a person was hired into the company. My boss wants a Pop-Up List to keep him aware of employees who are in their month following their anniversary within the company (to help organize vacation periods). The Pop-Up List should jump out every time a database session begins.

In other words, a Pop-Up List of employees whose Month Field = "0" (zero) and whose Year Field is equal or higher than "1" (one).

Is there such a thing within Filemaker? Can it be done?

If not, how about a Dynamic Layout that only displays employees whose Month = 0 & Year >= 1.

Thanks to all for a wonderful Forum.

Hi,

Well, it would be rather straightforward to have a related value list of your employees based on a the result of a calculation

Case(Calc <1, "Yes", "No")

Now here is a link to a thread where the poster wanted week counts.

You may easily adapt it to Month, then create a relationship from a global in the main (populated with "Yes") to the Case Calculation in the related file.

HTH.

Yowza, Ugo! That's quite a thread you linked there. I'm going to study it for a while. Thanks.