Primary Key dependant of another field

S

Shack XiaMi

Let's say John Doe comes and tells us that he is from the Tampa Bay region
(TMB). So, the first thing that we enter is the region, which it will then
create the ID, so that John Doe's ID would look like TMB2341.
 
J

Jeff Boyce

I understand the concept, I just don't agree with it!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top