Hi all,
I am creating a data entry database for a client using Access 2003. They want there invoice number to be the primary key. It's alphanumeric. I have never created a primary key with a alpanumeric field. Can this be done effieciently? If so; how? What datatype to choose. This obviously has to be inputed not incremented correct?
Thanks