How to control duplicate entery?

[Tulsiram]

I am making payrole i want to restrict duplicate entry of worker.Can it be controlled by name of worker if it is reentered in the same month of same year?and how it can be controled?

[Søren Dyhr]

Try to see if this nails down your problem:

http://www.filemakerpros.com/DUPNTH.zip

--sd

[comment]

See here:

http://fmforums.com/forum/showtopic.php?tid/188843

In any case, you should use a unique EmployeeID instead of a name - names are not necessarily unique. So your calculation could look something like:

EmployeeID & "|" & Year ( PaymentDate ) & "|" & Month ( PaymentDate )