Primary key - Appending and auto number to a set prefix

Hi Nam, Thank you for the post, welcome to the forum, in answer to your question, try this, create your database or amend your existing database, in the ID field which I assume you have as an Autonumber field, (remember you can only link an autonumber to a Double Integer field), in the Table design view, select the ID field and in the Format line of the field properties enter the following for your Premier Table.

"PREM"000000

With the zeros being the number of numbers you require, for your other table obviously substitute the PREM with CAST,

I hope that works, it usually does, if so, please click the Resolved link, best regards Pete