>This comment will help me find where to put procedures. I'm a newie to VFP - what would a function look like that checked against Employee.employeeno? If you don't mind.

The functions in the stored procedure part of the DBC are identical to those you would use in normal code. To call them from the validate clause, simply put in the function name with any parameters.

In terms of checking against employee.employeeno, you will need to perform a seek or locate for the number you have entered, and return either true or false depending on the required result. It may help to have an index on the employeeno field for speed.

If you look at the tastrade samples included with vfp there are stored procedures in the dbc which work on the above principles. Try taking one of theses and adapting it to your requiremets.

Hope this helps.

Cheers
Steve Lea

Cheers
Steve Lea