The title of this question may sound easy. I have the following problem: given a sheet where staff members must write their first- and last name. Some of the staff members do exchange first- and last name (so a lookup is not successful). Is their any way to solve this (I have a SQL database containing all information)?
Ultimately, staff members can write their staff id and / or their key id on the sheet. My idea was to use on or both of this values to lookup the person. But again, sometimes none of the fields are given.
What would be they correct / a good way to solve this problem? Shall I write a web service where this four fields are sent to and a object containing the best match is returned? Any advices?