Forum home » Delegate support and help forum » Microsoft Access Training and help » Primary key and first field in a table...
|
|
|
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. |
Primary key and first field in a table...
Resolved · Urgent Priority · Version 2003
Reply Wed 17 Dec 2008, 11:03Delegate Emma said...
Emma has attended:
Access Intermediate course
Access Introduction course
Primary key and first field in a table...
Does thje first field in the table have to be a number? Like account number etc? or can it be text? and also can i confrim that if so this would be the primary key?
For upcoming training course dates see: Pricing & availability
RE: primary key and first field in a table...
Hi Emma,
Thank you for your question;
In reply: No it does not have to be a number, you can use text for a primary key as well, the only stipulation is that it must be unique... ie for a Department Table, MK for Marketing, SA for Sales, FI for Finance all perfectly acceptable, account number could be a mixture of both ie company name and number Tesco = TES01 -- get the picture?
I hope that helps ...Pete
Wed 24 Dec 2008: Automatically marked as resolved.
|