creating a combo id for a primary key

G

GVaught

No. you can't do this at the table level. Primary Keys can't be based on
calculated fields. Your users would have to type this value combination in.
You can create a input mask that would ensure they enter the key as
LetterLetterLetterLetterNumNum. See help on InputMask for exact formatting.

Autonumber will not solve your number increment problem.
 
Top