[AccessD] 2 quick questions

> 1)
> The data for the program I am working on, comes w/no real good unique 
> identifier, so I'm trying to create my own.  The only personal data I am 
> getting is name (last, first, MI) and DoB. The rest is survey data. This 
> is a dental survey form, and they want to track clients if/as they go from 
> infant to adult, so I told them we need some sort of identifier.
>
> The method I've come up with, to create an identifier is using the 1st 3 
> letters of the last name, the 1st 2 of the first name, the middle 
> initial...if there isn't one, I place an "X" into the ID...then 6 digits 
> of DoB.
>
> For example: a client named Joe T Murphy, born on Dec 7th, 1994 would be 
> assigned an ID of MURJOT120794
>
> It is not air-tight, so to speak, but I don't see another way...I'm just 
> looking for opinions on this...


=========Who's going to use this identifier and how will they apply it? If 
you just need a unique value, just use an AutoNumber. Why are you going to 
all this trouble?

Susan H.