This problem--if it is a problem might be unsolveable--but here goes;
I have a ACCESS database that primarily serves as a customer address book; small wholesale business that when a customer purchases, the staff (3) tries to get the information for various things. (sometimes in person, sometimes phone)
Sometimes they only put in the first name and leave the last name field blank--but alas the LASTname field is required, so they invent names like among the people using it.
Unknown is a popular one--
However, when I run the DB for dupes and whatnot, this poses a problem.
Is there a way to create linking fields that will move down a set of criteria; first name, address, business (if any information pulled from customer company checks), telephone number, that uniquely sorts the first name field?