A
Alan Stump
Hi folks,
Perhaps somebody out there can help me with the following
issue:
I am a relatively novice, low-impact user of Access who is
trying to create a database of land parcels that my
company has considered purchasing in the past. This is a
simple enough task, but I am hung up on how to create a
custom, sequential, and fully automatic numbering system
(like an autonumbered primary key, I suppose).
Essentially, I want the numbering system to be composed of
a two-letter county code followed by a four-digit number.
For instance, the fourth piece of land we looked at in
Orange County would be designated as OR-0004, the 81st
deal we looked at in Lake county would be LA-0081, the
23rd deal in Sumter would be SU-0023, and so on.
The key here is that the numbering system will be unique,
sequential, and completely automatic. For instance, if I
tell the database that a deal is in Orange County, I want
it to automatically recognize that it is the 73rd piece of
land in Orange county that I am entering into the system,
and automatically assign a number of OR-0073. The next
piece of land in Orange county that I enter in, I want the
system to automatically give it the number OR-0074,
without any prompting from me.
The system should be as automatic, user-friendly, and
error-proof as possible. Can somebody out there please
give me some hints on how I can do this?
Many thanks in advance,
Alan
Perhaps somebody out there can help me with the following
issue:
I am a relatively novice, low-impact user of Access who is
trying to create a database of land parcels that my
company has considered purchasing in the past. This is a
simple enough task, but I am hung up on how to create a
custom, sequential, and fully automatic numbering system
(like an autonumbered primary key, I suppose).
Essentially, I want the numbering system to be composed of
a two-letter county code followed by a four-digit number.
For instance, the fourth piece of land we looked at in
Orange County would be designated as OR-0004, the 81st
deal we looked at in Lake county would be LA-0081, the
23rd deal in Sumter would be SU-0023, and so on.
The key here is that the numbering system will be unique,
sequential, and completely automatic. For instance, if I
tell the database that a deal is in Orange County, I want
it to automatically recognize that it is the 73rd piece of
land in Orange county that I am entering into the system,
and automatically assign a number of OR-0073. The next
piece of land in Orange county that I enter in, I want the
system to automatically give it the number OR-0074,
without any prompting from me.
The system should be as automatic, user-friendly, and
error-proof as possible. Can somebody out there please
give me some hints on how I can do this?
Many thanks in advance,
Alan