Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How to combine parts of fields to form an updated field to make an intelligible Primary key?

I would like to make a Primary key field which has some meaning to me. For example, say I have list of customers FIRSTNAME, LASTNAME, but I want to make a field which combines these to make a recognizable primary key for me, such as the first seven letters of the the LASTNAME (IF THERE ARE SEVEN) and the first four letters of the FIRSTNAME, plus a number (just in case there are tow identical names) eg. SmithJohn001, SmithJohn002, JenkinsMary1, etc. Can I create that end result with the first and last name fields or at least combine the fields as stated and add simply the # 1 at the end, which could be modified to avoid duplicates. Another example would be to combine the numbers in the date of birth field, to the first 3 letters of the lastname and the first letter of the first name. I know this must be possible.

How to combine parts of fields to form an updated field to make an intelligible Primary key?

I would like to make a Primary key field which has some meaning to me. For example, say I have list of customers FIRSTNAME, LASTNAME, but I want to make a field which combines these to make a recognizable primary key for me, such as the first seven letters of the the LASTNAME (IF THERE ARE SEVEN) and the first four letters of the FIRSTNAME, plus a number (just in case there are tow identical names) eg. SmithJohn001, SmithJohn002, JenkinsMary1, etc. Can I create that end result with the first and last name fields or at least combine the fields as stated and add simply the # 1 at the end, which could be modified to avoid duplicates. Another example would be to combine the numbers in the date of birth field, to the first 3 letters of the lastname and the first letter of the first name. I know this must be possible.

How to combine parts of fields to form an updated field in order to make create an intelligible Primary key?

I would like to make create a Primary key field which has some meaning to me. For example, say I have list of customers FIRSTNAME, LASTNAME, but I want to make a field which combines these to make a recognizable primary key for me, such as the first seven letters of the the LASTNAME (IF THERE ARE SEVEN) (if there are 7 letters in the name) and the first four letters of the FIRSTNAME, plus a number (just in case there are tow identical names) eg. SmithJohn001, SmithJohn002, JenkinsMary1, etc. Can I create that end result with the first and last name fields or at least combine the fields as stated and add simply the # 1 at the end, which could be modified to avoid duplicates. Another example would be to combine the numbers in the date of birth field, to the first 3 letters of the lastname and the first letter of the first name. I know this must be possible.