The database I'm working on has a calculated field in a table. This field holds the number of working days between an initial date (stored in the same table) and the current date obtained with the Get(CurrentDate) function.
The difficulty is that I need to take into account vacation days stored in another table. The working days calculation is specific to a person and each person has his/her own unique vacation schedule. I was thinking to do the calculation via a custom function, however, I have found no way to search a table from within a custom function. Have I missed something about custom functions in this regard?
I would appreciate any suggestions about how to approach this problem using custom functions or otherwise.