Check flag to see if date is in table of dates

[mark s reynard]

I have a table containing date fields, which are basically holiday dates.

In an unrelated table I want a calculation field which is a flag to say whether a date entered is listed in the holiday table.

The method i'm using is by 1, creating a valuelist based on the holidaydate field for all values in the holiday table. I then created a calculation field in the holiday table using valuelistitems to have all the values in a field.

I was then going to to a test

If(not IsEmpty ( FilterValues ( Bank Holidays::holidays all ; Working Date ));1;0)

But is doesnt seem to work.

I apologise if this has been answered elsewhere, but i searched the forums and couldn't find a solution.

Any help appreciated.

Thanks

[comment]

I then created a calculation field in the holiday table using valuelistitems

But if the calculation field is in the (unrelated) holiday table, then you're back to where you started. Why not check the entered date directly against ValueListItems()?

BTW, wouldn't it be simpler to add a relationship?