I'm importing information from several different users. They have various info including FIrstName, LastName and DOB.
I've created a Combined info field which is the first five digits to the left of each of the three fields. Ex. Joseph Smith, 15/01/85 would be JosepSmith15/01. Now, what I am wondering if there a way to have it assign each a serial number, BUT, not in the standard way. As these lists are combined from several users, Joe Smith could be on four different lists with different info, so I want it to give the same ID number to those with matching combined fields. Is this something that can be done through a calculation or anything?