I'm not sure if i explained it clearly below but here's my dilemma:
I have a database where we store all the information on our staff. In this database, I have a calcuation that states : If ( Month ( DOB ) = Month (Get ( CurrentDate )) and
Day ( DOB ) = Day (Get ( CurrentDate ));1)
In the other database, I have it a relationship for the calculation field in my personnel database (i.e, this relationship is only true if the month and day matches a birthday). This way, on birth dates, a little message pops up that says "Happy Birthday! XYZ" and a little picture.
This is not working :(. This link does not dynamically update daily, so i have to manually check if anyone has a birthday on any particular day and then retype their birthday into the DOB field to force the calculation to update.
Is there a way to automate this? If so, how?