I would welcome some advice as to how to solve this basic query.
I have a series of customer details and I want to prompt the user, ideally when they advance the form to a new record, when they they enter a name which is the same as one which already exists. I have a form with a forename and surname text field and an unbound text box which add these together.
I am then hoping to check this unbound text against all other entries to see if it a duplicate. I could use the no duplicates rule although there may an occassion where a duplicate entry is needed.
I have a series of customer details and I want to prompt the user, ideally when they advance the form to a new record, when they they enter a name which is the same as one which already exists. I have a form with a forename and surname text field and an unbound text box which add these together.
I am then hoping to check this unbound text against all other entries to see if it a duplicate. I could use the no duplicates rule although there may an occassion where a duplicate entry is needed.
