>I want a validation rule for my Activity.employeeno field that checks against Employee.employeeno for such an employeeno.

>Thanks for advice.
I know I've seen this somewhere, but I can't find it now

I presume you are using a DBC. If so, create a stored procedure in the DBC and call this function in the valid clause of the table (table designer.)

Cheers
Steve Lea