Specific ID keys

[Formating Field in Access Table]

I have an assignment for a class where I am creating a Database an assignment. The problem is that for one of the fields I can't figure out how to format the field to do what I need it to do. This is the infomation I have about it
Primary key, the ID of the table, including the first two characters of the customers last name (from a different table), and a 4 digit number (AB1234 for example). Ther is no need to create a validation rules or input masks to ensure this.
I am clueless as how to do this, or if it is even possible with this program and maybe they just want us to put it in manually. Help please

 

[Rebecca Riordan]

Sweetie, as a general rule, we tend to avoid doing people's homework around
here, but I'll give you a nudge in the general direction of your solution:
it can't be done in the table design.

--
Rebecca Riordan, MVP

Designing Relational Database Systems
Microsoft SQL Server 2000 Programming Step by Step
Microsoft ADO.NET Step by Step

http://www.microsoft.com/mspress

Blessed are they who can laugh at themselves,
for they shall never cease to be amused...

I have an assignment for a class where I am creating a Database an

assignment. The problem is that for one of the fields I can't figure out how
to format the field to do what I need it to do. This is the infomation I
have about it:

Primary key, the ID of the table, including the first two characters of

the customers last name (from a different table), and a 4 digit number
(AB1234 for example). Ther is no need to create a validation rules or input
masks to ensure this.

I am clueless as how to do this, or if it is even possible with this

program and maybe they just want us to put it in manually. Help please