assign a unique identifier

[doninca]

I need my database to auto assign a name or number to a record. The user
would enter the first 4 digits which would identify a branch office. Such as
2250. There are four offices. Upon that entry a unique number (or
identifier) needs to be added to the same field. The purpose of this is to
uniquely identify an event. This unique identifier would be tied to other
tables as people are assigned to attend the event. Also, there is an
attendance capacity. Once the maximum attendance is met, I need the user to
recognize additional people cannot sign up for the event.

Any feedback on this is appreciated.

 

[Fred]

You didn't specify what it is unique to. Each record? If so you simplest
solution is to separate that into two fields, the second being an autonumber,
and just concentation them when the identifier is needed.

 

[Steve]

You need tables that look like ........
TblBranchOffice
BranchOfficeID
BranchOfficeName

TblPerson
PersonID
PersonName
etc

TblEvent
EventID
EventName
EventStartDate
EventEndDate

TblRegistration
Registration
RegistrationID
EventID
PersonID

Use of these tables does away with the need for the complexity of auto
assigning a name or number to a record.

Steve
(e-mail address removed)

 

[doninca]

You didn't specify what it is unique to. Each record? If so you simplest
solution is to separate that into two fields, the second being an autonumber,
and just concentation them when the identifier is needed.

Each meeting needs a unique identifier. So, the record of the meeting which contains the location and contact information. Thank you for your suggestion. I am going to look at both suggestions received and figure out what is best for our needs. thank you so much

 

[doninca]

You need tables that look like ........
TblBranchOffice
BranchOfficeID
BranchOfficeName

TblPerson
PersonID
PersonName
etc

TblEvent
EventID
EventName
EventStartDate
EventEndDate

TblRegistration
Registration
RegistrationID
EventID
PersonID

Use of these tables does away with the need for the complexity of auto
assigning a name or number to a record.

Steve
(e-mail address removed)





I appreciate your help. I am going to look at both suggestions to determine which will better meet our needs. Thank you again. I am surprised that people are so helpful and generous with their time and knowledge.