check if Value in Global Field is in a value list

[Crazyhorse]

I'm working on a timeclock database, and need to verify if the data antered in a global employee ID field is in the value list of current employees. It seems simple, but I can't find how to do it in Version 6.

[TheTominator]

With a value list named "CurrentEmployeeIDs" and a global numeric field "gEmployeeID", you could use this to give 1 if the value is in the list and 0 otherwise.

Case(

PatternCount(

"¶" & ValueListItems(Status(CurrentFileName), "CurrentEmployeeIDs") & "¶", "¶" & gEmployeeID & "¶") > 0, 1,

0

)

[Crazyhorse]

Thanks! Forest for the trees sometimes...