maximyshka
asked on
Use "-" in the unique field
Hi, does it make any difference whether or not I will use "-" in the Unique number field.
Example "1111111111-222222". We have such field in master file for reporting purposes.
Unique field is the main field we use for programming, groupping, indexing, reporting etc.
Is this OK to use field "1111111111-222222" or I have to use field "1111111111222222" as primary key and use field ""1111111111-222222" for reporting purposes
Example "1111111111-222222". We have such field in master file for reporting purposes.
Unique field is the main field we use for programming, groupping, indexing, reporting etc.
Is this OK to use field "1111111111-222222" or I have to use field "1111111111222222" as primary key and use field ""1111111111-222222" for reporting purposes
Last Comment
You can use "-" in a unique number field. However, it is obviously text and not a number. Neither will it be automatically incremented as an Autonumber type. Your only requirements would be uniqueness.
ASKER
I have a field in the format 1111111121-2222222 which I want to use as primary key. Yes this field i text. Incrementing not needed
Then, yes, you may include and use the "-".
Lee
Lee
ASKER
MX, autonumber will not work. Value "1111111121-2222222" is uniquely identify all information about this loan.
Something similar to composite key
1111111121
2222222
Something similar to composite key
1111111121
2222222
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks a lot
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
mx