If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
assign a unique identifier
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. |
#2
|
|||
|
|||
assign a unique identifier
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. "doninca" wrote: 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. |
#4
|
|||
|
|||
assign a unique identifier
"Fred" wrote: 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" wrote: 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. |
#5
|
|||
|
|||
assign a unique identifier
"Steve" wrote: 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 "doninca" wrote in message ... 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. 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. |
Thread Tools | |
Display Modes | |
|
|