Primary Key dependant of another field

  • Thread starter Thread starter Shack XiaMi
  • Start date Start date
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.
 
I understand the concept, I just don't agree with it!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Primary Key dependant of another field 1
Same record/Primary key in multiple tables 0
Primary Key Help 4
Very Strange Database Phenomena! 11
primary key - concatenated or autonumber? 6
Primary Keys & Forms 4
Listbox to open a form (primary key text) 2
Update primary Key. 1

Back
Top