Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access courses - Primary Key
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
microsoft access courses - Primary Key
Resolved · Low Priority · Version Standard
Reply Thu 21 Jun 2007, 10:03Delegate Dan said...
Dan has attended:
Excel Advanced course
Access Intermediate course
Primary Key
How do we combine the first to letters of FName and the first 3 letters of LName to create employee PK for dB?
For upcoming training course dates see: Pricing & availability
RE: Primary Key
Hi Dan
To do this you would need to have all the details submitted to a form before they went anywhere the actual database. You would then need to write some code to get the letters that you need and join them. then submit to a database.
I would also say that the primary key has to be unique, so what would happen if two people had the same name?
I suggest you give you primary key a little more thought and make sure that there is no way that a duplicate will exist.
Hope this helps
David
|