You could create a field that concatenated the name and pid and in validation require this field to be unique.
But, I think, I am still unclear. Will FMk12 alert me to the fact that a particular name has already been entered or is it to
just not let me enter a duplicate name.
Tks for the response.
IfM will not allow the entry. As well, you could have a custom message displayed if validation fails.
You might find this name look up demo helpful. It will check for duplicate names and requjire the user to refine their selection when there are two ore more duplicate names.
FileMaker 12 users: https://dl.dropbox.com/u/78737945/SimpleNameLookupDemo.fmp12
Pre FileMaker 12 Users: https://dl.dropbox.com/u/78737945/SimpleNameLookupDemo.fp7